Julian Date Convert
Posted: Tue Nov 23, 2004 7:48 pm
Hi,
I've date coming from DB2-AS400 as Julian . I'm able to succefully convert dates with using Functions
Ans=Oconv(Iconv(TheDate, "DYJ"), "D-YMD[4,2,2]")
Input - 90313
output - 1990-11-09
But I've dates coming in format for example :104314 i.e. 2004-11-09 for which above routine do not works. To make it simple where the i/p julian format is of 5 lenght the routine works but when it the source come as 6 length it fails ot I'm not able to convert data for year above 1999
Can someone suggest how to convert the dates in this format.
Regards,
Munish
I've date coming from DB2-AS400 as Julian . I'm able to succefully convert dates with using Functions
Ans=Oconv(Iconv(TheDate, "DYJ"), "D-YMD[4,2,2]")
Input - 90313
output - 1990-11-09
But I've dates coming in format for example :104314 i.e. 2004-11-09 for which above routine do not works. To make it simple where the i/p julian format is of 5 lenght the routine works but when it the source come as 6 length it fails ot I'm not able to convert data for year above 1999
Can someone suggest how to convert the dates in this format.
Regards,
Munish