Gopal Gopal - 22 days ago 8
SQL Question

How to display a day from the Date

Using SQL Server 2005

Table1

Date

19-12-2009
20-12-2010
.....


Date Column datatype is
DATETIME
.

Expected Output

Monday
Tuesday


How to make a query for getting the day...

Answer

You can use the DATENAME function.

SELECT DATENAME(WEEKDAY,[Date])
FROM Table1
Comments