Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
Round Quarter
Rounds the date to the beginning of the quarter, i.e. leaving the year unchanged and setting the month and day to the beginning of the quarter and setting hour, minute, second and millisecond to their base value
Syntax
ROUND_QUARTER(column)
Examples
[1] Round dates from the beginning of a quarter to the beginning of the quarter.
Query
Column1
ROUND_QUARTER ( "Table1"."Column1" )
[2] Round dates from the middle of a quarter to the beginning of the quarter.
Query
Column1
ROUND_QUARTER ( "Table1"."Column1" )
[3] Round dates from the end of a quarter to the beginning of the quarter.
Query
Column1
ROUND_QUARTER ( "Table1"."Column1" )