If you would like to upgrade to a newer long-term support version of Studio Pro, see Moving from Mendix Studio Pro 8 to 9.
OQL DATEPART
Last modified: August 27, 2024
The DATEPART function retrieves a specified element from a date/time values. This element is of type integer.
The syntax is as follows:
DATEPART ( datepart , date_expression )
datepart | definition | example when used for Friday July 1, 2005, 16:34:20 |
---|---|---|
YEAR |
2005 | |
QUARTER |
1, 2, 3 or 4 | 3 |
MONTH |
1 to 12 | 7 |
DAYOFYEAR |
1 to 366 | |
DAY |
1 to 31 | 5 |
WEEK |
1 to 53 (depends on the database implementation) | |
WEEKDAY |
1 to 7 (1 = Sunday, 7 = Saturday) | 6 |
HOUR |
0 to 23 | 16 |
MINUTE |
0 to 59 | 34 |
SECOND |
0 to 59 | 20 |
datepart Specifies the part of the date/time value to retrieve. This can be one of the following:
date_expression Specifies the date to retrieve an element from. This should be formatted in an expression which resolves to a date/time value.