Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    212

    Unanswered: Date format to include day of week

    Hi

    Does any one know how to format a date in SQL Server so that it includes the abbreviated day of the week and no time part e.g.

    Mon 25/12/2009

  2. #2
    Join Date
    Jan 2003
    Location
    British Columbia
    Posts
    44
    Declare @Date datetime
    set @Date = '25-Dec-2009'
    select left(datename(dw,@Date),3) + ' ' + convert(varchar,@Date,103)

    Fri 25/12/2009

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •