Julian Timestamp

  • All,

    I am hearing this word first time. what it is ? I have serached on Websites. But i didn't get clear information about it . Can anybody explain it with simple example ?

    Inputs are welcome !

    karthik

  • Please take a look at this:


    Regards,

    goodguy

    Experience is a bad teacher whose exams precede its lessons

  • Any inputs apart from the above one ?

    karthik

  • My experience with Julian dates is from a mainframe system.

    The Julian date used was an integer composed of the 4 digit year plus the number of the day of the year.

    Examples

    2008001 = 1/1/2008

    2008031 = 1/31/2008

    2008040 = 2/1/2008

    etc.

    The dates I worked with did not have a time component. That was stored in a separate field.

  • The main purpose of the Julian date (in the old days of IT) was to put the date in an easily sortable form. This was before date and datetime datatypes. I don't know of any real purpose it would have in present-day IT environments except for making some old-timers feel comfortable -- and, of course, training exercises.

    Tomm Carr
    --
    Version Normal Form -- http://groups.google.com/group/vrdbms

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply