Skip to main content

Celonis Product Documentation

ROUND_SECOND
Description

This function rounds a DATE input down to the second by setting its MILLISECOND values to their ground state.

Syntax
 ROUND_SECOND ( table.date_column )
NULL handling

If the input value is NULL, then the result is NULL as well.

Example

[1]

Round dates down to the second:

Query

Column1 

         ROUND_SECOND ( "Table1"."Date" )

Input

Output

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

null

Result

Column1 : date

Mon May 08 2006 23:59:59.000

Fri Dec 31 1999 23:59:59.000

Fri Jan 01 2016 00:59:59.000

Sat Jan 01 1994 00:00:00.000

null