Conversion Julian date to Gregorian date on DB2 load

#1 (**permalink**) 02-27-2008, 09:01 AM

Hello,

I have Julian date in format YYDDD in the load file.
A column in the table to be loaded has regular date format.
I am using IBM load utility. How can I convert data?
(In JCL before Load I can put some logic to modify Julian date field to
YYYYDDD)

Thank you very much.
Mike

#2 (**permalink**) 02-27-2008, 09:01 AM

DATE function accept 'yyyyddd' as input and convert it to standard date
type.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode