Return a part of a date.
DATEPART(interval, date, [firstdayofweek, firstweekofyear])
interval - required, string that indicates the interval of time to return
date - required, date to evaluate
firstdayofweek - [OPTIONAL] constant that indicates the first day of the week
firstdayofyear - [OPTIONAL] constant that indicates the first week of the year
The date is the date to be used in the calculation and this example returns 2018.
The DATEPART function can be used with any of the valid interval values. These interval values are: Year ("yyyy" or "yy"), Quarter ("q"), Month ("m" or "mm"), Day of Year ("y"), Day ("d" or "dd"), Week ("ww"), Hour ("h"), Minute ("n"), and Second ("s").
The DATEPART function can be used to get the day of the week of a date. The "w" argument specifies that the day of the week is to be returned. The date is the date to be used in the calculation. This example returns 4, which is Wednesday.
The DATEPART function is a useful date/time function that can be used to extract a portion of a date/time value.
The DATEPART function can be used to extract the part of a date, such as year, month, or day.
The DATEPART function is a date/time function.
Frequently Asked Questions
What does the DATEPART function do?
The DATEPART function takes four arguments and returns a variant. It can be used to determine the date of a specific interval.
What are the arguments for the DATEPART function?
The arguments for the DATEPART function are interval, date, firstdayofweek, and firstdayofyear.
Are the firstdayofweek and firstdayofyear arguments optional?
Yes, both the firstdayofweek and firstdayofyear arguments are optional.
What does the firstdayofweek argument do?
The firstdayofweek argument determines the first day of the week.
Can the DATEPART function return the wrong week number?
Yes, the DATEPART function can return the wrong week number because the last Monday in some calendar years is not week 1 instead of week 53.