select DATENAME(week, '2002-09-30 11:35:00') : DATENAME « Date Timezone « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Date Timezone
  3. DATENAME

select DATENAME(week, '2002-09-30 11:35:00')

 


5> select DATENAME(week, '2002-09-30 11:35:00')

------------------------------
40

(1 rows affected)








Related examples in the same category

1.DATENAME returns the part of the date in a literal form.
2.Using the DATENAME() Function
3.Find out the month name in two months time
4.DATENAME: return the part of the date in a literal form
5.DATENAME(month, '4-29-1988') returns a string containing the descriptive name
6.select DATENAME(day, '2002-09-30 11:35:00')
7.select DATENAME(year, '2002-09-30 11:35:00')
8.select DATENAME(hour, '2002-09-30 11:35:00')
9.select DATENAME(minute, '2002-09-30 11:35:00')
10.select DATENAME(second, '2002-09-30 11:35:00')
11.select DATENAME(quarter, '2002-09-30 11:35:00')
12.select DATENAME(dayofyear, '2002-09-30 11:35:00')
13.select DATENAME(weekday, '2002-09-30 11:35:00')