DATEPART

Returns the specified part of a given date

DATEPART( date , date part)

Returns the specified date part for the given date/time element or array of dates.

Arguments

Argument	Description
date	Date/time value(s)
date part	Part of the date/time objects to return

Output

Date part for each input date

Example