How to use sql server DATENAME () Function

 Introduction

In my previous tip I have been posted about DATEADD () function. Another function can use for date and time related operation in Sql server called DATENAME (). The DATENAME () returns a character string representing the specified datepart of the specified.date.

DATENAME() Syntax

DATENAME(datepart,datetime)

DECLARE @Today DATETIME
SET @Today=GETDATE() --'15-Dec-2010'


SELECT DATENAME(month, @Today) -- Get the month from date
SELECT DATENAME(mm, @Today )
SELECT DATENAME(m, @Today)
------------Output-----------------------------
----------------------------------------------
--December


SELECT DATENAME(dayofyear, @Today)  -- select day of year, its return current day from 1 of jan 
SELECT DATENAME(dy,@Today)
SELECT DATENAME(y, @Today)
------------Output-----------------------------
-----------------------------------------------
--349

SELECT DATENAME(day, @Today) -- select the day of the month
SELECT DATENAME(dd, @Today)
SELECT DATENAME(d, @Today)
------------Output-----------------------------
-----------------------------------------------
--15

SELECT DATENAME(week, @Today) -- get week numbre of the year
SELECT DATENAME(wk,@Today)
SELECT DATENAME(ww, @Today)
------------Output-----------------------------
-----------------------------------------------
--51

SELECT DATENAME(hour, @Today) -- select the current hour for now
SELECT DATENAME(hh, @Today)
------------Output-----------------------------
-----------------------------------------------
--13

SELECT DATENAME(minute, @Today) -- select the current minute for now
SELECT DATENAME(mi, @Today)
SELECT DATENAME(n, @Today)
------------Output-----------------------------
-----------------------------------------------
--45

SELECT DATENAME(second , @today) -- select the current seocnd for now
SELECT DATENAME(ss, @today)
SELECT DATENAME(s, @today)
------------Output-----------------------------
-----------------------------------------------
--34

SELECT DATENAME(millisecond , @today) -- select the current milliseconds for now
SELECT DATENAME(ms, @today)
------------Output-----------------------------
-----------------------------------------------
--340