DATEPART Function in SQL Server: Tips and Examples

DATEPART Function in SQL Server is easier to understand when the core ideas are paired with practical examples. The sections below explain the topic clearly, highlight useful steps, and point out details that can prevent common errors.

You will show you in detail how to use the DATEPART () datetime processing function in SQL Server with specific syntax and examples to better visualize and capture functions.

Describe

The DATEPART function in SQL Server returns a time value of the input argument, which can be day, month, year, quarter, hour, minute, second, millisecond. The return value is an integer type (int)

Syntax

To use the DATEPART function in SQL Server, we use the following syntax:

 DATEPART(dangthoigian, thoigian)

Parameters :

dangthoigian: the type of time you want. It may be one of the following values:

Value Explanation year, yyyy, yy Year of quarter, qq, q Quarter month, mm, m Month dayofyear Date in day, dy, y Week, ww, wk Weekday, dw, w Day in week hour, hh Hour minute, mi, n Minutes second, ss, s Second millisecond, Milli milliseconds

DATEPART can be used in later versions of SQL Server: SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005.

As an example,

See and explore some examples of DATEPART functions in SQL Server.

 SELECT DATEPART(year, '2019/04/28'); 
 Result: 2019 
 
 SELECT DATEPART(yyyy, '2019/04/28'); 
 Result: 2019 
 
 SELECT DATEPART(yy, '2019/04/28'); 
 Result: 2019 
 
 SELECT DATEPART(month, '2019/04/28'); 
 Result: 4 
 
 SELECT DATEPART(day, '2019/04/28'); 
 Result: 28 
 
 SELECT DATEPART(quarter, '2019/04/28'); 
 Result: 2 
 
 SELECT DATEPART(hour, '2019/04/28 09:49'); 
 Result: 9 
 
 SELECT DATEPART(minute, '2019/04/28 09:49'); 
 Result: 49 
 
 SELECT DATEPART(second, '2019/04/28 09:49:12'); 
 Result: 12 
 
 SELECT DATEPART(millisecond, '2019/04/28 09:49:12.726'); 
 Result: 726

Next lesson: DAY function in SQL Server

FAQ

What should you know about describe?

The DATEPART function in SQL Server returns a time value of the input argument, which can be day, month, year, quarter, hour, minute, second, millisecond. The return value is an integer type (int).