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
date time
a date
unit
keyword
Date unit keyword
Possible values: year, month, week, day, hour, minute or second.