temporal_routines

SYNOPSIS

Temporal routines: stored functions managing temporal values. All functions are DETERMINISTIC, NO SQL.

  • easter_day(): Returns DATE of easter day in given DATETIME's year.
  • is_datetime(): Check whether given string is a valid DATETIME.
  • start_of_hour(): Returns DATETIME of beginning of round hour of given DATETIME.
  • start_of_month(): Returns first day of month of given datetime, as DATE object
  • start_of_quarter(): Returns first day of quarter of given datetime, as DATE object
  • start_of_week(): Returns first day of week of given datetime (i.e. start of Monday), as DATE object
  • start_of_week_sunday(): Returns first day of week, Sunday based, of given datetime, as DATE object
  • start_of_year(): Returns first day of year of given datetime, as DATE object


 
common_schema documentation