Results 1 to 2 of 2

Thread: Date format

  1. #1
    Join Date
    Jan 2004
    Posts
    35

    Unanswered: Date format

    How do I get the following date format 2005-01-31 to be 01/31/2005?

    SELECT
    convert(datetime,Convert(varchar(10),getdate(),20) ,110) as Date

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    select convert(varchar,getdate(),101) ???

Posting Permissions

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