Page History
Panel | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||
MONTHThis function returns the month of a date or dateTime value. The month is returned as a number in the range 1 - 12. Syntax
Inputs
Return type
Examples
|
Panel | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
DAYThis function returns the day of a date or dateTime value. The day is returned as a number in the range 1 - 31. Syntax
Inputs
Return type
Examples
|
Panel | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
HOURThis function returns the hour of a dateTime value. The hour is returned as a number in the range 0 - 23. Syntax
Inputs
Return type
Examples
|
Panel | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
MINUTEThis function returns the minute of a dateTime value. The minute is returned as a number in the range 0 - 59. Syntax
Inputs
Return type
Examples
|
Panel | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
SECONDThis function returns the second of a dateTime value. The second is returned as a number in the range 0 - 59. Syntax
Inputs
Return type
Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
TODAYThis function returns the current date of the server. The date is given as base type date, formatted as dd-mm-yyyy. Syntax
Return type
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
NOWThis 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
Return type
|
Panel | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||
WEEKNUMBERThis 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
Inputs
Return type
Examples
|
Panel | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||
DAYOFWEEKThis function returns the number of the day within the week of a given date or dateTime value, as follows:
Inputs
Examples
|