A simple datetime conversion

• DBABC

  SSCarpal Tunnel

  Points: 4813

  More actions

  August 1, 2008 at 1:47 pm

  #190429

  How can i convert 'Friday, August 15, 2008, 7:30 pm' to '08/15/2008'??

  i need the sql query....i have searched all the datetime functions and convert options but i could not find one...

  any idea?

  Thanks,

  Usman

• Steven Cameron

  SSCrazy

  Points: 2903

  More actions

  August 1, 2008 at 2:06 pm

  #852171

  If you drop the 'Friday' and the commas, then

  SELECT CONVERT(varchar(10), CONVERT(datetime, 'August 15 2008 7:30 pm', 100), 101)