Hi, Could you please anyone help me on the below requirement.
I need to convert Julian date to date using schema file, I tried the below format, but which is not working.
date:nullable date {date_format='%cc%yy%ddd', null_field='0000000'};
date:nullable date {date_format='%yyy%ddd', null_field='0000000'};
Please anyone help me to know what is the correct format for ccyyddd (julian date) in schema file.
Thanks in advance.
How to convert JULIAN DATE to DATE using schema file
Moderators: chulett, rschirm, roy
What's the format of your incoming date? The format string should specify that format...i.e. the format you're wanting to convert from.
If this were an output stage, it would be the format you're wanting to convert to.
Regards,
If this were an output stage, it would be the format you're wanting to convert to.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
So you're using an ordinal date (year and day number within year) rather than a Julian date (days offset from a known zero date)?
Try "%yyyy%ddd" as the format string.
Try "%yyyy%ddd" as the format string.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: