Date conversion
Posted: Mon Feb 09, 2009 12:42 pm
Hi guys,
The source data is coming in from mainframe and when i import the CFD, the columns are in decimal and of format "0207354", "0197356".
When I decoded this, the first 2 character represents the century which is if 02 , then 2007 or if 01 then 1900 . the next 2 characters represents the year in tht century which is 2007 or 1997 and the last 3 represents the day in the year.
Is there a way to use functions to implement this?, as of now i am using stage variables and " if and else conditions" and concatinating it back. I got to do these conversion for almost 100 columns and target is orcale of datatype "Date".
Thanks for your response
The source data is coming in from mainframe and when i import the CFD, the columns are in decimal and of format "0207354", "0197356".
When I decoded this, the first 2 character represents the century which is if 02 , then 2007 or if 01 then 1900 . the next 2 characters represents the year in tht century which is 2007 or 1997 and the last 3 represents the day in the year.
Is there a way to use functions to implement this?, as of now i am using stage variables and " if and else conditions" and concatinating it back. I got to do these conversion for almost 100 columns and target is orcale of datatype "Date".
Thanks for your response