Post reply

date format

  • July 23, 2008 at 6:27 am

    #75267

    Is there a way to get just the weekday from a datetime column, i.e. "Wednesday" ?

    Thanks

    Sam

  • July 23, 2008 at 6:46 am

    #846983

    SELECT DATENAME(dw,YourDate). Look up DATENAME and DATEPART in BOL.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

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

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