timingskey
SSCommitted
Points: 1708
More actions
July 28, 2003 at 3:25 pm
#151889
Does anyone know how to get the day of week to return from a from a datetime value? For example, how could I get SQL Server to tell me that this date (2003-07-27 23:55:02.093)was a Sunday?
Thanks!
5409045121009-7368
SSCoach
Points: 15740
July 28, 2003 at 3:34 pm
#467369
Select DATENAME(dw , Cast('2003-07-27 23:55:02.093' as DateTime))
Don't have to do the cast bit!
July 28, 2003 at 3:42 pm
#467370
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply