Problem with date formating

• cidr

  Ten Centuries

  Points: 1353

  More actions

  October 16, 2009 at 8:27 am

  #72542

  Hi folks,

  I've looked everywhere to find a technique that will format the date as dd-mmm-yyyy within a stored proc without using a function.

  Does anyone know if there are any articles or ways to do this? The format's not built into SQL server.

  Thanks

• cidr

  Ten Centuries

  Points: 1353

  More actions

  October 16, 2009 at 8:35 am

  #1066937

  Thanks for anyone who looks at this, however, I found the answer

  select replace(convert(char(11),getdate(),113),' ','-')

  Cheers

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  October 16, 2009 at 9:15 am

  #1066984

  Most of the formats are here: http://msdn.microsoft.com/en-us/library/ms187928.aspx

• cidr

  Ten Centuries

  Points: 1353

  More actions

  October 16, 2009 at 9:18 am

  #1066987

  Cheers Steve, I looked at BOL, however I didn't notice 113.

  🙂