You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
DAYOFWEEK
This function returns the number of the day within the week of a given date or dateTime value, as follows:
- Sunday = 1
- Monday = 2
- Tuesday = 3
- Wednesday = 4
- Thursday = 5
- Friday = 6
- Saturday = 7
DAYOFWEEK ( date | dateTime )
Inputs
- date or dateTime - The date or dateTime value of which the week number must be returned.
- integer
Examples
Expression | Result | Type |
---|---|---|
DAYOFWEEK ( DATE ( 2015 , 01 , 01 ) ) | 5 | Integer |
DAYOFWEEK ( DATETIME ( 2015 , 12 , 28 , 0 , 0 , 0 ) ) | 2 | Integer |
DAYOFWEEK ( DATE ( 2016 , 01 , 02 ) ) | 7 | Integer |
DAYOFWEEK ( ? ) | UNKNOWN | Integer |
Overview
Content Tools