Page 1 of 1
Converting date from dd/mm/yy to yyyy/mm/dd in parallel
Posted: Thu Jul 17, 2008 1:04 pm
by cnu
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
Posted: Thu Jul 17, 2008 1:18 pm
by chulett
Search the forums for "century pivot", I found at least two posts with a possible solution in them for you.
Posted: Thu Jul 17, 2008 1:25 pm
by filename.txt
In stage Output>Format>Timestamp In Format String instead of %yy% use %2000yy%
Re: Converting date from dd/mm/yy to yyyy/mm/dd in parallel
Posted: Sat Jul 19, 2008 1:19 pm
by cnu
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
Posted: Sat Jul 19, 2008 2:11 pm
by chulett
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.
Posted: Sat Jul 19, 2008 3:43 pm
by ray.wurlod
Search for CENTURYPIVOT both here and in the manuals.