Functions

---

day(date:)

Extracts the day of the month from a date value (1-31).

day(date: DATE) -> INTEGER

day_of_week(date:)

Returns the day of the week from a date (1-7, where 1 is Monday).

day_of_week(date: DATE) -> INTEGER

day_of_year(date:)

Day of the year (starts from 1, i.e., January 1 = 1).

day_of_year(date: DATE) -> INTEGER

hour(date:)

Extracts the hour from a date/time value (0-23).

hour(date: DATE) -> INTEGER

microsecond(date:)

Extracts the microsecond from a date/time value (0-999999).

microsecond(date: DATE) -> INTEGER

millisecond(date:)

Extracts the millisecond from a date/time value (0-999).

millisecond(date: DATE) -> INTEGER

minute(date:)

Extracts the minute from a date/time value (0-59).

minute(date: DATE) -> INTEGER

month(date:)

Extracts the month from a date value (1-12).

month(date: DATE) -> INTEGER

quarter(date:)

Extracts the quarter from a date value (1-4).

quarter(date: DATE) -> INTEGER

second(date:)

Extracts the second from a date/time value (0-59).

second(date: DATE) -> INTEGER

timezone_hour(date:)

Extracts the timezone hour from a timestamp with timezone.

timezone_hour(date: DATE) -> INTEGER

timezone_minute(date:)

Extracts the timezone minute from a timestamp with timezone.

timezone_minute(date: DATE) -> INTEGER

week(date:)

Returns the week number from a date (1-53).

week(date: DATE) -> INTEGER

year(date:)

Extracts the year from a date value.

year(date: DATE) -> INTEGER