Displaying the String Value for Part of a Date : DATENAME « Date Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Date Functions
  3. DATENAME
DATENAME returns a string value for the part of a date specified in the datepart code. The syntax is:
DATENAME ( datepart , date )

The second parameter designates the date to base the string value on.








10.7.DATENAME
10.7.1.Displaying the String Value for Part of a Date
10.7.2.DATENAME returns date's character string representation: DATENAME(datepart,date)
10.7.3.select DATENAME(day, '2002-09-30 11:35:00')
10.7.4.select DATENAME(month, '2002-09-30 11:35:00')
10.7.5.select DATENAME(year, '2002-09-30 11:35:00')
10.7.6.select DATENAME(hour, '2002-09-30 11:35:00')
10.7.7.select DATENAME(minute, '2002-09-30 11:35:00')
10.7.8.select DATENAME(second, '2002-09-30 11:35:00')
10.7.9.select DATENAME(quarter, '2002-09-30 11:35:00')
10.7.10.select DATENAME(dayofyear, '2002-09-30 11:35:00')
10.7.11.select DATENAME(week, '2002-09-30 11:35:00')
10.7.12.select DATENAME(weekday, '2002-09-30 11:35:00')
10.7.13.select DATENAME(month,'2002-09-30')
10.7.14.Combining this with DATEADD allows you to find out the month name in two months time:
10.7.15.Displaying the String Value for Part of a Date: Show the start Date's day of the week