using date_from_string function in modify stage
Posted: Sat Nov 05, 2005 7:56 am
Hi
I have input data Datestring as string to the modify stage in the format "05112005"(ddmmyyyy)
Using modify stage i need to convert the Datestring to date 11-05-2005(mm-dd-yyyy).
In the specification property of modify stage i type:
Newdate:date = date_from_string[%dd%mm%yyyy](Datestring)
The result being date converted as "2005-11-05"(yyyy-mm-dd) which is the default format of datastage
Is there any way i can convert date in one format to another format other than yyyy-mm-dd using date_from_string function using modify stage.
Thanks
Balaji
I have input data Datestring as string to the modify stage in the format "05112005"(ddmmyyyy)
Using modify stage i need to convert the Datestring to date 11-05-2005(mm-dd-yyyy).
In the specification property of modify stage i type:
Newdate:date = date_from_string[%dd%mm%yyyy](Datestring)
The result being date converted as "2005-11-05"(yyyy-mm-dd) which is the default format of datastage
Is there any way i can convert date in one format to another format other than yyyy-mm-dd using date_from_string function using modify stage.
Thanks
Balaji