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

Example


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

Query
Column1
DAY_OF_WEEK ( "Table1"."Column1" )
Input
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
Output
Result
Column1 : INT
0
1
2
3
4
5
6


  • No labels