How to find Date Name in MSSQL:
if you want to return a weekday or date name of particular date then it is so simple in MSSQL.
See the example:
select DATENAME(dw , getDate())
This query returns today’s date name like Sunday, Monday etc.
You can pass “dw” or “weekday” as a first parameter to date name which specifies the part of date returned.
Filed under: How to find Date Name | Tagged: datename, dateName function in SQL, dw, getdate(0, How to find Date Name, How to find Date Name in MSSQL, how to return date name in SQL, how to return dayname in SQL, how to return weekday in SQL
[...] Snippet(s): Select Records Less Than 24 Hours Old | How to find date name in MSSQL [...]
Simply you can pass your date in this query
select DATENAME(dw , '2009-01-01')
------------Thursday