Reader Level:
ARTICLE

DATEPART Function in SQL Server 2012

Posted by Rohatash Kumar Articles | SQL Server December 12, 2012
In this article, I would like to show the Datepart Function in SQL Server.
  • 0
  • 0
  • 7161

In this article, I would like to show the Datepart Function in SQL Server. The Datepart Function is a built-in function. The Datepart Function returns a portion or single part of a SQL Server Datetime field. So let's have a look at a practical example of how to use a Datepart Function in SQL Server 2012. The example is developed in SQL Server 2012 using the SQL Server Management Studio.

The Datepart Function

The SQL Server Datepart function returns a portion of a SQL Server Datetime field. 

Syntax

The syntax of the Datepart built-in date function is as follows :

DATEPART ([Date part], [Datetime])

Here, the <Date part> parameter is the part of the datetime. Datetime is the name of a SQL Server Datetime field and portion is one of the following:

Ms        Milliseconds
Yy Year
Qq Quarter of the Year
Mm Month
Dy The Day of the Year
Dd Day of the Month
Wk Week
Dw The Day of the Week
Hh Hour
Mi Minute
Ss Second

Example 1

Select  getdate() as CurrentDate

Go

Select datepart(Yy, getdate()) As Year

Go

Select datepart(Mm, getdate()) As Month

Go

Select datepart(Dd, getdate()) As Month

Go

Select datepart(Wk, getdate()) As Week

Go

Select datepart(Dw, getdate()) As [Day of the Week]

Go

Select datepart(Dy, getdate()) As [Day of the Year]

Go

Select datepart(Hh, getdate()) As Hour

Go

Select datepart(Mi, getdate()) As Minute

Go

Select datepart(Ss, getdate()) As Second

Output

Datepart-Function-in-SQL-Server.jpg

Example 2

Now I want to check that date was in AM or PM with Datepart function.

Select  getdate() as CurrentDate

Go

Select case

          when datepart( hour, getdate()) < 12 then 'It''s AM'

          else 'It''s PM'

       end 'Date'

 

Output

Datepart-Function-with-am-and-pm-in-SQL-Server.jpg

COMMENT USING

Trending up