Post reply

Retrieve name day of week

  • April 30, 2009 at 9:20 am

    #73610

    I am wanting to retrieve the named day of the week(Monday, Tuesday, etc) in a T-SQL statement. Does anyone have any code/knowledge they are willing to share to help me achieve this?

  • April 30, 2009 at 9:26 am

    #986719

    SELECT DATENAME(WEEKDAY ,GETDATE())

  • May 1, 2009 at 9:29 pm

    #987662

    SELECT DATENAME (dw, GETDATE())

    ________________________________________________________________
    "The greatest ignorance is being proud of your learning"

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

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