FunctionsDate & Time

parse_datetime_best_effort_or_zero

Parses text into UTC epoch seconds using permissive timestamp parsing and returns zero on parse failure.

parse_datetime_best_effort_or_zero(…) → Int64

Kind · scalar

Parses text into UTC epoch seconds using permissive timestamp parsing and returns zero on parse failure.

Part of the Date & Time family.

parse_datetime_best_effort_or_null

Parses text into UTC epoch seconds using permissive timestamp format handling and returns null on failure.

parse_datetime_best_effort_us

Parses text into UTC epoch seconds using permissive parsing, with support for fractional microsecond-style inputs.