Problem while parameter for date

[hhh]

Hello friends

I m using job parameter for date ,and datatype is date .

but when i enter the date as 0001-01-01 it gives output as 2005-01-01
similarly for 0002-01-01 gives 2002-01-01
0030-01-01 gives 1930-01-01
0099-01-01 gives 1999-01-01
0029-01-01 gives 2029-01-01

can u please say what is going on ?


regards

Hman

[roy]

Hi,
Seems like it's treating those as 2 digit years.
Is there any problem in using a string type instead?

(Trying to remember is there any configuration to force proper interpretation )

[ray.wurlod]

Welcome aboard! :D

DataStage has rules for handling of two digit dates. They are converted into the century defined by the CENTURYPIVOT configuration parameter; by default the century 1930-2029.

It also appears that the underlying mechanism is treating 00yy as yy.

I have no explanation for '0001-01-01 it gives output as 2005-01-01' I would have expected 2001-01-01 given the other examples.

However, I would expect '0000-01-01' to generate 2005-01-01, since 0 is understood to be "current year". There is no year 0; the year before 1AD is 1BC.

Interestingly, the underlying query engine is unaffected. Iconv("0001-01-01", "DYMD") returns -718432 which converts back to 1 Jan 1AD.

[hhh]

Hi Roy,

for datatype as string it gives appropriate value.

Thx

Hman