You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
DAY
This function returns the day of a date or dateTime value. The day is returned as a number in the range 1 - 31.
Syntax
DAY ( date | dateTime )
- date or dateTime - The date or dateTime value of which the day must be returned.
Return type
- integer
Examples
Expression | Result | Type |
---|---|---|
DAY ( DATE ( 2015 , 01 , 01 ) ) | 1 | Integer |
DAY ( DATE ( 1978 , 04 , 11 ) ) | 11 | Integer |
HOUR
This function returns the hour of a dateTime value. The hour is returned as a number in the range 0 - 23.
Syntax
HOUR ( dateTime )
- dateTime - The dateTime value of which the hour must be returned.
Return type
- integer
Examples
Expression | Result | Type |
---|---|---|
HOUR ( DATETIME ( 2015 , 5 , 25 , 00 , 00 , 00 ) ) | 0 | Integer |
HOUR ( DATETIME ( 2015 , 5 , 25 , 23 , 00 , 00 ) ) | 23 | Integer |
MINUTE
This function returns the minute of a dateTime value. The minute is returned as a number in the range 0 - 59.
Syntax
MINUTE ( dateTime )
- dateTime - The dateTime value of which the minute must be returned.
Return type
- integer
Examples
Expression | Result | Type |
---|---|---|
MINUTE ( DATETIME ( 2015 , 5 , 25 , 00 , 00 , 00 ) ) | 0 | Integer |
MINUTE ( DATETIME ( 2015 , 5 , 25 , 23 , 45 , 00 ) ) | 45 | Integer |
SECOND
This function returns the second of a dateTime value. The second is returned as a number in the range 0 - 59.
Syntax
SECOND ( dateTime )
- dateTime - The dateTime value of which the second must be returned.
Return type
- integer
Examples
Expression | Result | Type |
---|---|---|
SECOND ( DATETIME ( 2015 , 5 , 25 , 00 , 00 , 00 ) ) | 0 | Integer |
SECOND ( DATETIME ( 2015 , 5 , 25 , 23 , 45 , 59 ) ) | 59 | Integer |
TODAY
This function returns the current date of the server. The date is given as base type date, formatted as dd-mm-yyyy.
Syntax
TODAY
Return type
- date
TODAY
function returns a date stamp. It is only recalculated when the expression in which you use the TODAY
function is reevaluated. This recalculation will not cause other expressions that use the TODAY
function to be reevaluated.
NOW
This function returns the current date and time of the server. The date and time are given as base type dateTime, formatted as dd-mm-yyyy HH:mm:ss.
Syntax
NOW
Return type
- dateTime
NOW
function returns a date- and timestamp. It is only recalculated when the expression in which you use the NOW
function is reevaluated. This recalculation will not cause other expressions that use the NOW
function to be reevaluated.
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
- Sunday = 1
- Monday = 2
- Tuesday = 3
- Wednesday = 4
- Thursday = 5
- Friday = 6
- Saturday = 7
DAYOFWEEK ( date | dateTime )
- date or dateTime - The date or dateTime value of which the week number must be returned.
- integer
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 |