how to convert 5 digit julian date to calendar date ?
Moderators: chulett, rschirm, roy
how to convert 5 digit julian date to calendar date ?
Hi ,
if any body has a solution please help.
the desired format is YYYY-MM-DD
or any other format will do .
if any body has a solution please help.
the desired format is YYYY-MM-DD
or any other format will do .
There is, unfortunately, no single definition or standard for "Julian Date". But DataStage has a function DateFromDaysSince() with which you can take the base date from your Julian and add the number of days to get a DATE value, which you can then format to your specifications. If your julian date happens to be the same as DataStages (which specifies "number of days from 4713 BCE January 1, 12:00 GMT") then you can use the builtin Julian date functions.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Of course that will give incorrect output. In order to do ANY date work, DataStage (and you) need to know what actual date is represented by "09134" -> is it Febrary 13th, 1242 or December 1st, 2005 or some other date? Once you know that date, then you can use the DateFromDaysSince function.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
Re: how to convert 5 digit julian date to calendar date ?
Hi Can you tell what is ur input and what is the out put u want
if possible quote an example
if possible quote an example
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,ray.wurlod wrote:If this is true you can use StringToDate() with an appropriate date format mask string. ...
I tried using the following format :
StringToDate(DSLink2.flm[12,5],"%yy%(ddd,v)")
but am getting the warning :
Transformer_9,0: Conversion error calling conversion routine date_from_ustring data may have been lost
Regards
Regards,
Ganesh
Ganesh
Hi Ray,ray.wurlod wrote:If this is true you can use StringToDate() with an appropriate date format mask string. ...
I tried using the following format :
StringToDate(DSLink2.flm[12,5],"%yy%(ddd,v)")
but am getting the warning :
Transformer_9,0: Conversion error calling conversion routine date_from_ustring data may have been lost
Regards
Regards,
Ganesh
Ganesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: