FunctionsDate & Time

sub_date

Subtracts a day count or interval from a date and returns the resulting date. This is a convenience alias for date_sub with date semantics (e.g., subtracting 7 days moves back one week).

sub_date(…) → Date

Kind · scalar

Subtracts a day count or interval from a date and returns the resulting date. This is a convenience alias for date_sub with date semantics (e.g., subtracting 7 days moves back one week).

Part of the Date & Time family.

parse_datetime64_best_effort_us_or_null

Parses text into epoch milliseconds with permissive parsing for microsecond-oriented inputs and returns null on failure.

time_as_blob

Encodes the input time/timestamp into a deterministic 8-byte hex string representation.