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
using date_from_string function in modify stage
Moderators: chulett, rschirm, roy
Re: using date_from_string function in modify stage
Hi Balajisr,
If you go to EDIT->PROPERTIES and edit the job properties in the Defaults tab you can find the default date and time formats used for the job. There u can set your specific format to be used for the job.
Sudarshan
If you go to EDIT->PROPERTIES and edit the job properties in the Defaults tab you can find the default date and time formats used for the job. There u can set your specific format to be used for the job.
Sudarshan
Hey,
Can u plss explain what use it will be to store three date fields in three different formats unless u r storing em as string ... because, whichever database u use will ultimately write to will store em in only one format. So, can u plss specify the datatypes u r abt to use, ur target and what exactly u want to achieve.
Sudarshan
Can u plss explain what use it will be to store three date fields in three different formats unless u r storing em as string ... because, whichever database u use will ultimately write to will store em in only one format. So, can u plss specify the datatypes u r abt to use, ur target and what exactly u want to achieve.
Sudarshan