another newbie question re: converting dates to other formats

• Amy Stuemky

  Mr or Mrs. 500

  Points: 592

  More actions

  December 6, 2005 at 4:15 pm

  #92678

  Okay, here's another thing I have been struggling with all afternoon... you all are so good at this, I'm hoping you can help me again.  🙂

  I have a date stored in a varchar field, in the following format:  2006-05-21 (yyyy-mm-dd).  I need to convert it to this format instead:  21MAY05 (ddMONyy), and then send it on to another table. 

  I've been trying the convert/cast stuff, but can't find anything that does 3-day months in there.  Any ideas?  Thanks for the help...

   

   

   

   

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  December 6, 2005 at 4:32 pm

  #608082

  Best option is something like this

   

  Declare @StringDate varchar(10)

  set @StringDate = '12/15/2005'

  select replace(convert(varchar(12), convert(datetime,@Stringdate), 6),' ','')