Converting Decimal(6,0) Data to SmallDateTime

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  May 3, 2007 at 9:42 am

  #172235

  Hello,

  I have a Decimal(6,0) column that contains date data in the following format; ymmdd. So May 1st 2007 looks like this; 70501.

  My first idea as to how to convert this to SmallDateTime would be like this;

  DECLARE @datevalue DECIMAL(6,0)

  SET @dateValue = 70501

  SELECT CONVERT(SmallDateTime,RIGHT(CAST((@datevalue * .000001)AS varchar(8)),6),1) AS NewDate

  Does anyone have a better idea?

  Thank you for your help!

  CSDunn

• Camilo Torres

  SSCrazy

  Points: 2034

  More actions

  May 3, 2007 at 10:33 am

  #704140

  if you data is for dates no older than 2000 and current year is the max(year)

  select

  convert(datetime,'200'+convert(varchar(10),@dateValue),110)

  else

  select convert(datetime,'199'+convert(varchar(10),@dateValue),110)

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  May 3, 2007 at 12:12 pm

  #704175

  Thanks for your help!

  CSDunn