Formatting Dates in SQL 2005

• tschuler-738392

  Ten Centuries

  Points: 1172

  More actions

  May 21, 2009 at 10:30 am

  #134361

  I am stuck trying to format a date field to output as MMDDYY. I can get it to come out as any of the following formats but need to have MMDDYY.

  yyyy/mm/dd

  yyyymmdd

  mm-dd-yyyy

  So basically I need to format the following data 2009-05-01 13:43:15 as 050109.

  Any help would be appreciated.

• Christopher Stobbs

  SSC-Insane

  Points: 21098

  More actions

  May 21, 2009 at 10:42 am

  #998397

  DECLARE @Date DATETIME

  SET @Date = '2009-05-01 13:43:15'

  SELECT REPLACE(CONVERT(varchar(13),@Date,10),'-','')

  Check out the CONVERT function in BOL

  ----------------------------------------------
  Try to learn something about everything and everything about something. - Thomas Henry Huxley

  :w00t:
  Posting Best Practices[/url]
  Numbers / Tally Tables[/url]

  SQL-4-Life

• tschuler-738392

  Ten Centuries

  Points: 1172

  More actions

  May 21, 2009 at 11:11 am

  #998412

  Thanks, that worked. I modified it a bit for a column I need to format.

  replace(convert(varchar(13),end_date,10),'-','')

• Christopher Stobbs

  SSC-Insane

  Points: 21098

  More actions

  May 22, 2009 at 2:12 am

  #998718

  Glad I could help

  ----------------------------------------------
  Try to learn something about everything and everything about something. - Thomas Henry Huxley

  :w00t:
  Posting Best Practices[/url]
  Numbers / Tally Tables[/url]

  SQL-4-Life