By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,292 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

Conversion Julian date to Gregorian date on DB2 load

P: n/a

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

Thank you very much.

Aug 28 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
DATE function accept 'yyyyddd' as input and convert it to standard date

Aug 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.