Date and Time Functions
The following functions can be used to get and set date and time data.
|
Function |
Usage |
Description |
|
|
Add days, weeks, months, and years to a date |
|
|
|
Add hours and minutes to a time |
|
|
|
Construct date from day, month and year |
|
| DATETIME2STR |   |
Return formatted string with date and time |
|
|
Return day number of a date |
|
|
|
Return day name of a date |
|
|
|
Return hours part of a time |
|
|
|
Return minutes part of a time |
|
|
|
Return month number of a date |
|
|
|
Return month name of a date |
|
| STR2DATE | |
Return formatted string with date in the IPE format |
| STR2TIME | |
Return formatted string with time in the IPE format |
|
|
Construct time from hour and minute |
|
|
|
Return week number of a date |
|
|
|
Return years part of a date |
Subtopics