Date and time projection
CALENDAR_WEEK
Description: Extracts the calendar week number from a timestamp value.
Syntax: CALENDAR_WEEK ( timestamp_column )
Example:
TABLE( CALENDAR_WEEK("Activities"."EVENTTIME") AS "CW" )
DAY
Description: Extracts the day of the month from a timestamp.
Syntax: DAY ( timestamp_column )
Example:
TABLE( DAY("Activities"."EVENTTIME") AS "Day" )
DAYS_IN_MONTH
Description: Returns the number of days in the month of a given timestamp.
Syntax: DAYS_IN_MONTH ( timestamp_column )
Example:
TABLE( DAYS_IN_MONTH("Activities"."EVENTTIME") AS "DaysInMonth" )
DAY_OF_WEEK
Description: Returns the weekday number for a timestamp.
Syntax: DAY_OF_WEEK ( timestamp_column )
Example:
TABLE( DAY_OF_WEEK("Activities"."EVENTTIME") AS "Weekday" )
HOURS
Description: Extracts the hour component from a timestamp.
Syntax: HOURS ( timestamp_column )
Example:
TABLE( HOURS("Activities"."EVENTTIME") AS "Hour" )
MILLIS
Description: Returns the millisecond component of a timestamp.
Syntax: MILLIS ( timestamp_column )
Example:
TABLE( MILLIS("Activities"."EVENTTIME") AS "Millis" )
MINUTES
Description: Extracts the minute component from a timestamp.
Syntax: MINUTES ( timestamp_column )
Example:
TABLE( MINUTES("Activities"."EVENTTIME") AS "Minutes" )
MONTH
Description: Extracts the month number from a timestamp.
Syntax: MONTH ( timestamp_column )
Example:
TABLE( MONTH("Activities"."EVENTTIME") AS "Month" )
QUARTER
Description: Returns the quarter of the year for a timestamp.
Syntax: QUARTER ( timestamp_column )
Example:
TABLE( QUARTER("Activities"."EVENTTIME") AS "Quarter" )
REMAP_TIMESTAMPS
Description: Adjusts timestamps according to a defined calendar or mapping rule.
Syntax: REMAP_TIMESTAMPS ( timestamp_column , time_unit [ , calendar_specification [ , calendar_id_column ] ] )
Example:
TABLE( REMAP_TIMESTAMPS("Activities"."EVENTTIME", DAYS) AS "DaysSinceEpoch" )
SECONDS
Description: Extracts the seconds component from a timestamp.
Syntax: SECONDS ( timestamp_column )
Example:
TABLE( SECONDS("Activities"."EVENTTIME") AS "Seconds" )
TO_TIMESTAMP
Description: Converts values such as strings into a timestamp format.
Syntax: TO_TIMESTAMP ( string_column , 'format' )
Example:
TABLE( TO_TIMESTAMP("T"."DateString", 'DD.MM.YYYY') AS "Date" )
YEAR
Description: Extracts the year component from a timestamp.
Syntax: YEAR ( timestamp_column )
Example:
TABLE( YEAR("Activities"."EVENTTIME") AS "Year" )