Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Converting Julian Dates to Text

by CountZero (Bishop)
on Oct 28, 2008 at 06:43 UTC ( #719922=note: print w/ replies, xml ) Need Help??


in reply to Converting Julian Dates to Text

From the Wikipedia:

The Julian date (JD) is the interval of time in days and fractions of a day, since 4713 BC January 1, Greenwich noon, Julian proleptic calendar.

Excel dates have unfortunately absolutely nothing to do with the Julian Date system.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James


Comment on Re: Converting Julian Dates to Text
Re^2: Converting Julian Dates to Text
by hawtin (Prior) on Oct 28, 2008 at 09:04 UTC

    In fact Julian dates do have day/month/year and were used up until the 16th century in much of Europe (until the 18th century in the UK and US and until the 20th in Russia and other places). The interval in days since 4713BC is used by astronomers and is usually called the Julian day. What the questioner really wants is the Gregorian date (i.e. what most people have been using since 1900).

    The distinction is only really important for historians, for example worrying about the fact that Russia's "October Revolution" took place in what most of the world thought of as November.

    As other posters have stated there are many CPAN modules for converting from Julian dates (or days) to and from Gregorian, Islamic, Jewish and all sorts of other dates (even Excel ones).

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://719922]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (8)
As of 2014-12-29 14:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (189 votes), past polls