Ora_Xfr_seq- Date conversion
Posted: Mon Nov 12, 2007 7:14 pm
Hi All,
I am trying to convert date format 20070331 24.2xxx to YYYYMMDD getting blanks in my target seq files.
using ds7.5.2 server jobs
i am pulling data from Oracle and loading into sequential file .
tried with Oconv(Iconv( input, "D/YMD[4,2,2]","D YMD[4,2,2]")
but not seeing any dates in my target.
let me know how to make conversion.
Thanks
Chandu
I am trying to convert date format 20070331 24.2xxx to YYYYMMDD getting blanks in my target seq files.
using ds7.5.2 server jobs
i am pulling data from Oracle and loading into sequential file .
tried with Oconv(Iconv( input, "D/YMD[4,2,2]","D YMD[4,2,2]")
but not seeing any dates in my target.
let me know how to make conversion.
Thanks
Chandu