HomeProgramSQL ServerDATEPART function in SQL Server

DATEPART function in SQL Server

This article 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 :

  1. 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
  1. thoigian: the amount of time you want to retrieve a value.

Note :

  1. The DATEPART function returns the result as an integer value.
  2. See also the DATENAME function which returns the same result as a string value.
  3. 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.

For 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

Previous article: DATENAME function in SQL Server

Next lesson: DAY function in SQL Server

4 ★ | 1 Vote
mssql functionsql server number handling functionsql server math function

You should read it

May be interested

  • IF commands ... ELSE in SQL ServerPhoto of IF commands ... ELSE in SQL Server
    like other programming languages, sql server also provides users with an if command el .... the article will detail how to use the syntax and clear examples to make it easier for you to imagine if ... else.
  • BREAK (Control Interrupt) command in SQL ServerPhoto of BREAK (Control Interrupt) command in SQL Server
    the break command used to exit the loop does not specify a stop condition or you want to stop the loop on condition that you specify and execute the statements following the loop statement end.
  • CONTINUE command in SQL ServerPhoto of CONTINUE command in SQL Server
    the continue command is used to give command execution authority to the last expression of the loop. that means upside-down to the top of the loop, all the commands that follow in the loop containing continue will be ignored without execution.
  • GOTO command in SQL ServerPhoto of GOTO command in SQL Server
    the goto command is a simple jump command, which allows an unconditional jump program from goto to a location in the program that has a label (laber) command in the same function.
  • Instructions for installing SQL Server 2019Photo of Instructions for installing SQL Server 2019
    on september 24, microsoft announced the release of sql server 2019 community technical preview (ctp) 2.0. it is very suitable for database professionals to keep up with modern technology.
  • WHILE loop in SQL ServerPhoto of WHILE loop in SQL Server
    the while loop is used if you want to run a code repeatedly when the given condition returns true. let's find out how to use while in sql server with network administrator.

SQL Server