Re: convert from Julian date to calendar date and vice verse [message #80704] |
Fri, 06 July 2012 10:56  |
k_ghreep
Messages: 19 Registered: May 2012
|
Junior Member |
|
|
On Jul 4, 5:19 pm, wlandsman <wlands...@gmail.com> wrote:
> Stefan, Sorry I misinterpreted your post. You didn't say that daycnv.pro had the wrong zero point, but that numbers given by the OP were not Julian dates since they had the wrong zero point.
>
> Khaled, to convert your numbers to Julian day you need to add JULDAY(1,1,1) = 1721424 to all your dates. But are you sure that your numbers are not *hours* rather than days since 1-1-1? If it is days then they refer to a year far in the future, but if they are hours then they refer to the year 2012.
>
> --Wayne
>
>
>
>
>
>
>
> On Tuesday, July 3, 2012 7:15:44 PM UTC-4, wlandsman wrote:
>> My posts from a few hours ago don't seem to have shown up -- sorry if they appear twice
>
>> daycnv.pro does not have the wrong zero point. It converts to Gregorian (not Julian) calendar day, and JD 0.0 corresponds to November 24 4713 BC in the Gregorian calendar.
>
>> ( e.g.http://www.hermetic.ch/cal_stud/jdn.htm#comp). Cheers, --Wayne
Hi Stefan and Wladsman
Thanks a lot for your efforts. I have got some fact for my date.
in fact all of the times are double values which represent the number
of days or hours from an origin date. I have got a units attribute for
the time variable that is considered the key to decoding the time
values. For example, my date have time units of "days since 1-1-1
00:00:0.0". With those units, an encoded value of 725738. would be the
value for the calendar date 1988-01-01.
I would like to convert my dates to readable times and vice versa. a
readable times means a calendar date in a form say 2012-010-25.
thanks in advance
Khaled
|
|
|