Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

DAY_OF_WEEK

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

Description

Returns the day of the week as number. The operator returns for Sunday 0, for Monday 1, for Tuesday 2 and so on.

Supported input column types: DATE

Output column type: INT

Syntax
DAY_OF_WEEK ( table.column )
NULL handling

If any parameter is NULL, the result is NULL as well.

Example

[1] In this example the result for every weekday is shown, beginning from Sunday.

Query

Column1

DAY_OF_WEEK ( "Table1"."Column1" )

Input

Output

Table1

Column1 : DATE

Sun Oct 14 2018 00:00:00.000

Mon Oct 15 2018 00:00:00.000

Tue Oct 16 2018 00:00:00.000

Wed Oct 17 2018 00:00:00.000

Thu Oct 18 2018 00:00:00.000

Fri Oct 19 2018 00:00:00.000

Sat Oct 20 2018 00:00:00.000

Result

Column1 : INT

0

1

2

3

4

5

6