How to convert date to julian date format in datastage
in coming date format is mm/dd/yyyy , i want to convert this date to julian date format.
Convert date to Julain date format in datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Julian means different things to different people. The conversion functions (Iconv() and OConv()) use "ordinal day within the year". If that's what you want use (or use "D/YJ" to get year first.
Code: Select all
Oconv(Iconv(InLink.TheDate, "DMDY"), "D/JY")
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.