Hi,
I am new to DataStage. Can u give me suggestion regarding how to write the expression in Datastage which was given in Informatica as below,
TO_DATE('01-01-1900 12:00:00')
Thanks in Advance,
Conversion of Date format in Datastage?
Moderators: chulett, rschirm, roy
Conversion of Date format in Datastage?
Thanks & Regards,
Kris
Kris
Kris,
there is more than one answer to your question in DataStage. The function (if any) to use depends upon the target database or file format that you want. Assuming you have a string coming in, you can use the ICONV() function to parse the date and time portions into their internal formats for either computational purposes or for re-conversion to another display output format.
there is more than one answer to your question in DataStage. The function (if any) to use depends upon the target database or file format that you want. Assuming you have a string coming in, you can use the ICONV() function to parse the date and time portions into their internal formats for either computational purposes or for re-conversion to another display output format.