469,271 Members | 1,431 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Conversion Julian date to Gregorian date on DB2 load

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
1 10214
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.

Similar topics

1 post views Thread by h_ghanaty | last post: by
1 post views Thread by Sam | last post: by
2 posts views Thread by =?Utf-8?B?cGVsZWdrMQ==?= | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.