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
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

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
type.

Aug 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.