Re: Convert Julian Hex Date to Another Format

Isn’t that the problem with “Julian” dates John. There’s more than one flavour!

I apparently have never encountered the “real” version before as defined here: "The Julian Day Number (JDN) is the integer assigned to a whole solar day in the Julian day count starting from noon Greenwich Mean Time, with Julian day number 0 assigned to the day starting at noon on January 1, 4713 BC, proleptic Julian calendar (November 24, 4714 BC, in the proleptic Gregorian calendar)."

Not quite sure how it can work though when you go that far back since I seem to recall there were a few calendar adjustments over the years - wasn’t there one in 1582 when Lilian dates started?


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Nov 24, 2014, at 12:53 PM, John Yeung <gallium.arsenide@xxxxxxxxx> wrote:

On Mon, Nov 24, 2014 at 12:29 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

Assuming that you want an RPG solution … I have no time to try this
but it should work if you just take a base date 0001/01/01 and add
the number of days.

No, it doesn't. Today (2014-11-24) is only day 735561, when counting
0001-01-01 as day 1.

But you can use the same technique, just with the proper offset.

date = d'0001-01-01' + %days(n - 1721426)

where n is the input integer.

Birgitta's SQL-based solution is the nicest, if you're willing to do
embedded SQL.

John Y.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.