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 Haybarn
SELECT CAST(STRPTIME('01/01/2000', '%m/%d/%Y') AS DATE)

SQLGlot example ↗

Apache Sparkto_timestamp()

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

SQLGlot example ↗

BigQueryparse_time()

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

SQLGlot example ↗

Exasolto_date()

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

SQLGlot example ↗

Oracleto_date()

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

SQLGlot example ↗

Prestodate_parse()

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

SQLGlot example ↗

SQL Serverconvert()

SELECT CONVERT(DATETIME, '2006-04-25T15:50:59.997', 126)
In Haybarn
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 Haybarn
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 Haybarn
EPOCH(STRPTIME(x, '%Y-%m-%d %H:%M:%S'))

SQLGlot example ↗