PQL46 (PQL Function Library - CPM 4.6)PQL 46Functions and operatorsDateTimeDateTime projectionDAYDAYApplies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6DescriptionReturns the day of a given date.Supported input column types: DATEOutput column type: INTSyntaxDAY( table.column )NULL handlingIf any parameter is NULL, the result is NULL as well.Example[1] Simple example for the DAY operator.QueryColumn1DAY ( "Table1"."Column1" )InputOutputColumn1Column1 : DATEMon Jan 01 2018 00:00:00.000Wed Jan 31 2018 00:00:00.000Thu Feb 01 2018 00:00:00.000ResultColumn1 : INT1311