DateTime Projection
Description
DateTime Projection Functions contains functions to extract the different parts from a DATE and to map DATEs to other data types and vice versa.
MILLIS, SECONDS, HOURS, DAY, MONTH and YEAR extract the corresponding date part from a DATE.
CALENDAR_WEEK, DAY_OF_WEEK, DAYS_IN_MONTH and QUARTER return the corresponding information about a DATE.
DATE_MATCH checks whether a DATE matches a specified pattern.
REMAP_TIMESTAMPS counts time units in specified intervals.