How can I convert the Julian date of iSeries DB2 in FM ?
I have no issue with Julian date conversion with Netezza DB, but no luck for iSeries DB2 for AS400.
Asked
Active
Viewed 690 times
0
-
I see that DB2 supports as input to the DATE function both "Unformatted Julian" and "Julian" formats, which use year number and day-of-year number. It also has a JULIAN DATE function which will output a count of days since January 1, 4713 BC, Julian proleptic calendar. I think you should give an example of a date you want to convert from, in the form you have it, and exactly what you want to convert it to. Hopefully you have an example conversion you know is correct. – Gerard Ashton Aug 01 '15 at 14:45
-
the julian date format i am getting from my source is 2015092 for 2015-04-01.. apart from that i am checking the _make_timestamp function of cognos fm.. what i found that if _make_timestamp (2015,1,33) yield 2015-02-02 : The extra day is carried to the consequence month... but _make_timestamp (2015,1,365) yield 2015-04-19 : I am expecting 2015-12-31. Any idea why it is so?.. perhaps i can apply _make_timestamp for this julian to date conversion.. – Chooi Ling Si Toh Aug 01 '15 at 16:27
-
Off the top of my head. Something like 2015-01-01 + 91 days – danny117 Aug 03 '15 at 16:25