Gopal Gopal - 10 months ago 60
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 Source

You can use the DATENAME function.

SELECT DATENAME(WEEKDAY,[Date])
FROM Table1