You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
WEEKNUMBER
This function returns the week number within the year of a given date or dateTime value. The week number is returned as an integer in the range 1 - 53. Week 1 for a year is the earliest seven day period starting at Monday that contains at least 4 days from that year. This definition reflects the ISO 8601 Week dates definition.
For example, January 1, 2015 was a Thursday. Therefore week 1 of 2015 starts on December 29, 2014, and ends on January 4, 2015.
Syntax
WEEKNUMBER ( date | dateTime )
Inputs
- date or dateTime - The date or dateTime value of which the week number must be returned.
Return type
- integer
Examples
| Expression | Result | Type |
|---|---|---|
| WEEKNUMBER ( DATE ( 2015 , 01 , 01 ) ) | 1 | Integer |
| WEEKNUMBER ( DATETIME ( 2014 , 12 , 28 , 0 , 0 , 0 ) ) | 1 | Integer |
| WEEKNUMBER ( DATE ( 2015 , 12 , 28 ) ) | 53 | Integer |
| WEEKNUMBER ( DATE ( 2016 , 01 , 02 ) ) | 53 | Integer |
| WEEKNUMBER ( DATETIME ( 2016 , 01 , 04 , 0 , 0 , 0 ) ) | 1 | Integer |
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