Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 To get the Day from a date(mm/ dd/yyyy)

Author  Topic 

vinuSan
Starting Member

1 Post

Posted - 2005-12-26 : 06:43:39
How can we get the week day details(eg. sunday, monday , tuesday etc) from a particular date value(mm/dd/yyyy).

Let me Grow...!!

shallu1_gupta
Constraint Violating Yak Guru

394 Posts

Posted - 2005-12-26 : 06:56:38
Try this
SELECT DATENAME(WEEKDAY, <datevalue>)
Go to Top of Page
   

- Advertisement -