Issues with Date formats
Posted: Thu Feb 14, 2008 5:31 am
Hello,
I have been trying to convert a date present in a flat file in yyyy-mm-dd format to mm-dd-yyyy format and store it in a database.
I have used a modify stage to convert the given date to string in mm-dd-yyyy format using String_Date_Function.
Now, before loading it into database as the string has to be converted into Date format,I tried to implement this using another modify stage and using function Date_from_string.
But the second Modify stage is giving an error and the job is being aborted.
Can anyone suggest a solution to this problem.
Or,else xan anyone suggest a different way out.
Thanks in advance.
I have been trying to convert a date present in a flat file in yyyy-mm-dd format to mm-dd-yyyy format and store it in a database.
I have used a modify stage to convert the given date to string in mm-dd-yyyy format using String_Date_Function.
Now, before loading it into database as the string has to be converted into Date format,I tried to implement this using another modify stage and using function Date_from_string.
But the second Modify stage is giving an error and the job is being aborted.
Can anyone suggest a solution to this problem.
Or,else xan anyone suggest a different way out.
Thanks in advance.