Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

ROUND_HOUR

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

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

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: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

null

NULL handling

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