Convert getdate() format

• Vik Nat

  Hall of Fame

  Points: 3930

  More actions

  July 31, 2003 at 4:23 pm

  #63332

  I want to convert getdate() from say something like this format '2003-07-31 15:16:32.937'(default value) to '7/31/2003 3:16:32 PM'. I tried to convert to varchar with various styles but no style returns the above output. The closest I came was

  select CONVERT(varchar(50) ,getdate(),100) which returned - 'Jul 31 2003 3:16PM'. Help would be greatly appreciated.

• mccork

  SSC-Insane

  Points: 22288

  More actions

  July 31, 2003 at 4:46 pm

  #468111

  Maybe a bit convoluted, but it does the trick:

  select CONVERT(varchar ,getdate(),101) + ' ' + LTRIM(STUFF(RIGHT(CONVERT(varchar ,getdate(),109), 14), 9, 4, ''))

  Cheers,

  - Mark

  
  Cheers,
  - Mark

• Vik Nat

  Hall of Fame

  Points: 3930

  More actions

  July 31, 2003 at 6:24 pm

  #468117

  Thank You Mark. That does do the trick.