FunctionsDate & Time

to_relative_year_num

Returns the number of calendar years elapsed since 1970 for each input value.

to_relative_year_num(…) → Int64

Kind · scalar

Returns the number of calendar years elapsed since 1970 for each input value.

Part of the Date & Time family.

to_relative_week_num

Returns the number of whole UTC 7-day windows elapsed since the Unix epoch for each input value.

to_second

Extracts the second component (0..59) from the input date or timestamp.