Converting date from dd/mm/yy to yyyy/mm/dd in parallel

cnu · Post by **cnu** » Thu Jul 17, 2008 1:04 pm

I am applying stringtodate function but i am getting 08 as 1908.bit i need a 2008.
Please let me know how i can approach.

Thanks
cnu

chulett · Post by **chulett** » Thu Jul 17, 2008 1:18 pm

Search the forums for "century pivot", I found at least two posts with a possible solution in them for you.

filename.txt · Post by **filename.txt** » Thu Jul 17, 2008 1:25 pm

In stage Output>Format>Timestamp In Format String instead of %yy% use %2000yy%

cnu · Post by **cnu** » Sat Jul 19, 2008 1:19 pm

Hi:

I want 19 when year from source is 99,98,90 etc.when ever sourc year is
08,07,03 etc it should pass 20 .

Please how can i resolve this requiremt.

Thanks
cnu

chulett · Post by **chulett** » Sat Jul 19, 2008 2:11 pm

Did you search for "century pivot"? That is what tells DataStage when to switch the century from 1900 to 2000, i.e. what year to 'pivot' the century change around.

ray.wurlod · Post by **ray.wurlod** » Sat Jul 19, 2008 3:43 pm

Search for CENTURYPIVOT both here and in the manuals.

DSXchange

Converting date from dd/mm/yy to yyyy/mm/dd in parallel

Converting date from dd/mm/yy to yyyy/mm/dd in parallel

Re: Converting date from dd/mm/yy to yyyy/mm/dd in parallel