Date and time rounding
ROUND_DAY
Description: Rounds a timestamp to the start of the day.
Syntax: ROUND_DAY ( timestamp_column )
Example:
TABLE( ROUND_DAY("Activities"."EVENTTIME") AS "StartOfDay" )
ROUND_HOUR
Description: Rounds a timestamp to the beginning of the hour.
Syntax: ROUND_HOUR ( timestamp_column )
Example:
TABLE( ROUND_HOUR("Activities"."EVENTTIME") AS "StartOfHour" )
ROUND_MINUTE
Description: Rounds a timestamp to the beginning of the minute.
Syntax: ROUND_MINUTE ( timestamp_column )
Example:
TABLE( ROUND_MINUTE("Activities"."EVENTTIME") AS "StartOfMinute" )
ROUND_MONTH
Description: Rounds a timestamp down to the beginning of the month.
Syntax: ROUND_MONTH ( timestamp_column )
Example:
TABLE( ROUND_MONTH("Activities"."EVENTTIME") AS "StartOfMonth" )
ROUND_QUARTER
Description: Rounds a timestamp to the beginning of the quarter.
Syntax: ROUND_QUARTER ( timestamp_column )
Example:
TABLE( ROUND_QUARTER("Activities"."EVENTTIME") AS "StartOfQuarter" )
ROUND_SECOND
Description: Rounds a timestamp to the beginning of the second.
Syntax: ROUND_SECOND ( timestamp_column )
Example:
TABLE( ROUND_SECOND("Activities"."EVENTTIME") AS "StartOfSecond" )
ROUND_WEEK
Description: Rounds a timestamp to the beginning of the week.
Syntax: ROUND_WEEK ( timestamp_column )
Example:
TABLE( ROUND_WEEK("Activities"."EVENTTIME") AS "StartOfWeek" )
ROUND_YEAR
Description: Rounds a timestamp down to the beginning of the year.
Syntax: ROUND_YEAR ( timestamp_column )
Example:
TABLE( ROUND_YEAR("Activities"."EVENTTIME") AS "StartOfYear" )l