Dates & time Scalar

try_strptime()

Converts the string text to timestamp according to the format string. Returns NULL on failure.

Arguments & returns

2 overloads

Scalar

Overload link	`text`	`format`	Returns
#01	`VARCHAR`	`VARCHAR`	`TIMESTAMP`
#02	`VARCHAR`	`VARCHAR[]`	`TIMESTAMP`

SELECT try_strptime('Wed, 1 January 1992 - 08:38:40 PM', '%a, %-d %B %Y - %I:%M:%S %p');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

TO_DATE(x, 'yyyy')

In DuckDB

CAST(CAST(TRY_STRPTIME(x, '%Y') AS TIMESTAMP) AS DATE)

SAFE_CAST(some_date AS DATE FORMAT 'DD MONTH YYYY')

In DuckDB

CAST(TRY_STRPTIME(some_date, '%d %B %Y') AS DATE)

SELECT TRY_TO_TIME('093000', 'HH24MISS')

In DuckDB

SELECT TRY_CAST(TRY_STRPTIME('093000', '%H%M%S') AS TIME)