FunctionsType Conversion

to_monday

Returns the date corresponding to Monday for the week containing the input date or timestamp.

to_monday(…) → Date

Kind · scalar

Returns the date corresponding to Monday for the week containing the input date or timestamp.

Part of the Type Conversion family.

to_modified_julian_day_or_null

Converts date or timestamp values to Modified Julian Day numbers and returns NULL on invalid input.

to_nullable

Wraps values in nullable form while preserving NULL rows and textual value representation.