Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 

Description

This function rounds a DATE input down to the hour by setting its MINUTE, SECOND and MILLISECOND values to their ground state.

Syntax

ROUND_HOUR ( table.date_column )

Example


[1] Round dates down to the hour:

Query
Column1
ROUND_HOUR ( "Table1"."Date" )
Input
Table1
Date : DATE
Mon May 08 2006 23:59:59.999
Fri Dec 31 1999 23:59:59.999
Fri Jan 01 2016 00:59:59.000
Sat Jan 01 1994 00:00:00.000
Output
Result
Column1 : DATE
Mon May 08 2006 23:00:00.000
Fri Dec 31 1999 23:00:00.000
Fri Jan 01 2016 00:00:00.000
Sat Jan 01 1994 00:00:00.000


  • No labels