Employees Table In this example, we want to find out what is the employees’ year of hire. Syntax DATEPART Reference Table Example Results The SQL DATEPART function can be very useful when you are interested in formatting the results using a specific format of a date and/or time.
