Dates & time
Scalar
strptime()
Converts the string text to timestamp applying the format strings in the list until one succeeds. Throws an error on failure. To return NULL on failure, use try_strptime.
Reference: DuckDB 2.0.0
Arguments & returns
2 overloadsstrptime(text, format)
Scalar
Converts the string text to timestamp according to the format string. Throws an error on failure. To return NULL on failure, use try_strptime.
| Overload link | text | format |
Returns |
|---|---|---|---|
| #01 | VARCHAR | VARCHAR |
TIMESTAMP |
strptime(text, format-list)
Scalar
| Overload link | text | format-list |
Returns |
|---|---|---|---|
| #02 | VARCHAR | VARCHAR[] |
TIMESTAMP |
Example
1 more โHaybarn WASM 2.0.0-rc12 ยท In your browser
Engine example ยท Run to view results.
More examples
Haybarn WASM 2.0.0-rc12 ยท In your browser
Engine example ยท Run to view results.
In other engines
PostgreSQLto_date()
SELECT TO_DATE('01/01/2000', 'MM/DD/YYYY')
SELECT CAST(STRPTIME('01/01/2000', '%m/%d/%Y') AS DATE)
Apache Sparkto_timestamp()
SELECT TO_TIMESTAMP(x, 'zZ')
SELECT STRPTIME(x, '%Z%z')
BigQueryparse_time()
SELECT PARSE_TIME('%H:%M', '14:30')
SELECT CAST(STRPTIME('14:30', '%H:%M') AS TIME)
Oracleto_date()
SELECT TO_DATE('2024-12-12', 'YYYY-MM-DD')
SELECT CAST(STRPTIME('2024-12-12', '%Y-%m-%d') AS DATE)
SQL Serverconvert()
SELECT CONVERT(DATETIME, '2006-04-25T15:50:59.997', 126)
SELECT STRPTIME('2006-04-25T15:50:59.997', '%Y-%m-%dT%H:%M:%S.%f')
Snowflaketo_date()
TO_DATE(x, 'MM-DD-YYYY')
CAST(STRPTIME(x, '%m-%d-%Y') AS DATE)
Used in larger rewrites 1
These examples use strptime as one part of a larger SQL translation.
Apache Hiveunix_timestamp()
UNIX_TIMESTAMP(x)
EPOCH(STRPTIME(x, '%Y-%m-%d %H:%M:%S'))