Extending minimum datetime values

• danielagger98

  Mr or Mrs. 500

  Points: 502

  More actions

  February 17, 2011 at 2:11 pm

  #388889

  I want to extend the minimum datetime value(1973), some of the oracle date fields have date 01-01-0006, not that it makes any sense.

  But if the management wants it, then they want it. So the SSIS pacakge is failing because it can't import datetime less than 1973 year. Please give me some ideas here. thanks.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  February 17, 2011 at 2:15 pm

  #1288518

  Please don't double-post.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• danielagger98

  Mr or Mrs. 500

  Points: 502

  More actions

  February 18, 2011 at 9:32 am

  #1288920

  Its desperation. My bad.

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  February 18, 2011 at 10:09 am

  #1288940

  If you want, then you need to keep the datatype as varchar not as datetime

  declare @Var1 datetime

  set @Var1='01/01/1752'

  Select CONVERT(datetime,@Var1)

  declare @Var2 varchar(20)

  set @Var2='01/01/1752'

  Select CONVERT(Varchar,@Var2)

  Thanks
  Parthi