Page History
Table of Contents | ||
---|---|---|
|
Panel | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||
DATETIMEYou can use this function to create a dateTime value out of integers or numbers.
Syntax
Return type
Examples
|
Panel | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||
DATEYou can use this function to create a date value out of integers or numbers.
Syntax
Return type
Examples
|
Panel | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||
ADD PERIOD TO DATEThis function calculates a new date by adding a specified period to a specified date. Syntax
Return type
Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
ADD PERIOD TO DATETIMEThis function calculates a new dateTime by adding a specified period to a specified dateTime. Syntax
Return type
Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SUBTRACT PERIOD FROM DATEThis function calculates a new date by subtracting a specified period from a specified date. Syntax
Return type
Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SUBTRACT PERIOD FROM DATETIMEThis function calculates a new dateTime by subtracting a specified period from a specified dateTime. Syntax
Return type
Examples
|
Panel | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||
PERIOD BETWEENThis function calculates the period between two date or dateTime objects. This function returns the number of full periods of the specified type between two dates or dateTimes. Valid types for period are:
Syntax
Return type
Examples
|
Panel | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||
WORKINGDAYS BETWEENThis function calculates the working days between two date or dateTime objects. It returns the number of full working days between two dates or dateTimes. The default working days are Monday, Tuesday, Wednesday, Thursday and Friday. This default can be overridden by supplying a list with alternative working days. Syntax
Return type
Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
YEAR
Syntax
Return type
Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
MONTH
Syntax
Return type
Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
DAY
Syntax
Return type
Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
HOUR
Syntax
Return type
Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
MINUTE
Syntax
Return type
Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SECOND
Syntax
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 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
WEEKNUMBER
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
Return type
Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
DAYOFWEEKDAYOFWEEK returns the number of the day within the week of a given date or dateTime value, as follows:
|