Functions/Dates & time/strptime
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.

Arguments & returns

2 overloads

strptime(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 textformat Returns
#01 VARCHARVARCHAR TIMESTAMP

strptime(text, format-list)

Scalar
Overload link textformat-list Returns
#02 VARCHARVARCHAR[] TIMESTAMP

Example

1 more ↓
strptime example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

More examples

strptime example 2
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

PostgreSQLto_date()

SELECT TO_DATE('01/01/2000', 'MM/DD/YYYY')
In DuckDB
SELECT CAST(STRPTIME('01/01/2000', '%m/%d/%Y') AS DATE)

SQLGlot example ↗

Apache Sparkto_timestamp()

SELECT TO_TIMESTAMP(x, 'zZ')
In DuckDB
SELECT STRPTIME(x, '%Z%z')

SQLGlot example ↗

BigQueryparse_time()

SELECT PARSE_TIME('%H:%M', '14:30')
In DuckDB
SELECT CAST(STRPTIME('14:30', '%H:%M') AS TIME)

SQLGlot example ↗

Exasolto_date()

TO_DATE(x, 'YYYY')
In DuckDB
CAST(STRPTIME(x, '%Y') AS DATE)

SQLGlot example ↗

Oracleto_date()

SELECT TO_DATE('2024-12-12', 'YYYY-MM-DD')
In DuckDB
SELECT CAST(STRPTIME('2024-12-12', '%Y-%m-%d') AS DATE)

SQLGlot example ↗

Prestodate_parse()

DATE_PARSE(x, '%Y-%m-%d')
In DuckDB
STRPTIME(x, '%Y-%m-%d')

SQLGlot example ↗

SQL Serverconvert()

SELECT CONVERT(DATETIME, '2006-04-25T15:50:59.997', 126)
In DuckDB
SELECT STRPTIME('2006-04-25T15:50:59.997', '%Y-%m-%dT%H:%M:%S.%f')

SQLGlot example ↗

Snowflaketo_date()

TO_DATE(x, 'MM-DD-YYYY')
In DuckDB
CAST(STRPTIME(x, '%m-%d-%Y') AS DATE)

SQLGlot example ↗

Used in larger rewrites 1

These examples use strptime as one part of a larger SQL translation.

Apache Hiveunix_timestamp()

UNIX_TIMESTAMP(x)
In DuckDB
EPOCH(STRPTIME(x, '%Y-%m-%d %H:%M:%S'))

SQLGlot example ↗