DuckDB function try_strptime — try_strptime • dd

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

Usage

try_strptime(text, format)

Arguments

text: VARCHAR
format: VARCHAR | VARCHAR[]

Value

TIMESTAMP

SQL examples

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