The DATEPART function is used in Microsoft SQL Server to return a single part of a date/time, such as year, month, day, etc..
Employees Table
| employeeID | employeeName | hireDate |
|---|
| 1000 | John Smith | 1995-12-03 |
| 1001 | Fred White | 2001-10-12 |
| 1002 | Jane Scott | 1998-05-01 |
| 1003 | Samuel Williams | 1991-01-03 |
In this example, we want to find out what is the employees' year of hire.
Syntax
|
DATEPART(datepart, column_name) |
DATEPART Reference Table
| datepart | abbreviation |
|---|
| year | yy, yyyy |
| quarter | qq, q |
| month | mm, m |
| dayofyear | dy, y |
| day | d |
| week | wk, ww |
| weekday | dw, w |
| hour | hh |
| minute | mi, n |
| second | ss, s |
| millisecond | ms |
| microsecond | mcs |
| nanosecond | ns |
| TZoffset | tz |
| ISO_WEEK | isowk, isoww |
Example
SELECT employeeName as [Employee Name], DATEPART(year,hireDate) as [Year Hired]
FROM employees
|
Results
| Employee Name | Year Hired |
|---|
| John Smith | 1995 |
| Fred White | 2001 |
| Jane Scott | 1998 |
| Samuel Williams | 1991 |
The SQL DATEPART function can be very useful when you are interested in formatting the results using a speficic format of a date and/or time.
Please help us spread the word by socializing it today!
Did you find something wrong with the information on this page? Please take a moment to report it to us
so that we can continue to improve the quality of the information on this site. Click here to
report an issue with this page.
Recommended Books & Training Resources
