Skip to content
Related Articles

Related Articles

DATENAME() Function in SQL Server
  • Last Updated : 18 Jan, 2021

DATENAME() function :

This function in SQL Server is used to find a given part of the specified date. Moreover, it returns the output value as a string.

Features :

  • This function is used to find a given part of the specified date.
  • This function comes under Date Functions.
  • This function accepts two parameters namely interval and date.
  • This function can also include time in the date section.
  • This function returns the output in string form.

Syntax :

DATENAME(interval, date)

Parameter :



This method accepts two parameters as given below.

  • interval –It is the specified part that is to be returned. Moreover, the values of the interval can be as given below.
year, yyyy, yy   = Year, which is the specified year.
quarter, qq, q   = Quarter, which is the specified quarter.
month, mm, m     = month, which is the specified month.
dayofyear, dy, y = Day of the year, which is the specified day of the year.
day, dd, d       = Day, which is the specified day.
week, ww, wk     = Week, which is the specified week.
weekday, dw, w   = Weekday, which is the specified week day.
hour, hh         = hour, which is the specified hour.
minute, mi, n    = Minute, which is the specified minute.
second, ss, s    = Second, which is the specified second.
millisecond, ms  = Millisecond, which is the specified millisecond.
  • date –It is the specified date which is to be used.

Returns :

It returns a given part of the specified date.

Example-1 :

Using DATENAME() function and getting the year part of the specified date.

SELECT DATENAME(year, '2021/01/06');

Output :

2021

Example-2 :

Using DATENAME() function and getting the month part of the specified date.



SELECT DATENAME(month, '2021/01/06');

Output :

January

Example-3 :

Using DATENAME() function and getting the day part of the specified date.

SELECT DATENAME(day, '2021/01/06');

Output :

6

Example-4 :

Using DATENAME() function and getting the hour part of the specified date which includes time as well.

SELECT DATENAME(hour, '2021/01/06 05:30');

Output :

5

Example-5 :

Using DATENAME() function and getting the second part of the specified date which includes time as well using a variable.

DECLARE @date VARCHAR(50);
SET @date = '2019/06/05 07:37:54';
SELECT DATENAME(second, @date);

Output :

54

Application :

This function is used to find the given part of the specified date.

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up
Recommended Articles
Page :