Skip to main content

Celonis Product Documentation

DAY_OF_WEEK
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