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.