Post reply

Getting day of week from datetime value

  • 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!

  • 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

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply