DatePart
Last updated
Last updated
The DatePart() function retrieves a part from a date. For example, the year, the month, the week, the day, the hour, the minutes or the seconds.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a number that is a part of a date. If the date is unknown then this function returns unknown.
Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.
| Name | Type | Required | Description |
|---|---|---|---|
| date time | a date | |
| keyword | Date unit keyword Possible values: year, month, week, day, hour, minute or second. |