chemker
Well Known Member
In iSeries query we've used the same method to convert julian dates to gregorian for years. Here's the calc in Define Result Fields:
Field Experession Len Dec
D1 juldate+1900000 7 0
DATE DATE(DIGITS(D1))
And this has worked great until we used a date in the year 2040. Now it seems the DATE expression runs into an issue, but I have not heard of any IBM issues with this.
Has anyone else seen this issue?
Thank you.
Field Experession Len Dec
D1 juldate+1900000 7 0
DATE DATE(DIGITS(D1))
And this has worked great until we used a date in the year 2040. Now it seems the DATE expression runs into an issue, but I have not heard of any IBM issues with this.
Has anyone else seen this issue?
Thank you.