HI,
i need the some information regarding the julian date convertion,
My input filed value:20031126(flatfile)
My Target field value(julian date):37949(sybase)
base date is 19000101.
How can i get this in datastage??????????????
Thanks
Learner
Juilan date Conversion
Moderators: chulett, rschirm, roy
Juilan date Conversion
Last edited by dslearner on Mon Aug 29, 2005 10:57 pm, edited 1 time in total.
If you take your base date and convert it to internal format ICONV("1900-01-01","D4-YMD") you can subtract that from the date in question ICONV(In.Date,"D4YMD") to get number of days since base. This is, I think, the date you are looking for.
Please refrain from using the word "urgent" in your posts, it will not get you an quicker responses - in fact I am sure that others read this before me and decided not to respond and I almost didn't do so as well because of that one word.
Please refrain from using the word "urgent" in your posts, it will not get you an quicker responses - in fact I am sure that others read this before me and decided not to respond and I almost didn't do so as well because of that one word.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: