Stardates again

I recently was reading Star Trek Chronology by Michael and Denise Okuda, which has some information about stardates.  They worked on all the Star Trek TV series, except the original one.  On page 95 they state:

Editor's Note: The year 2323 works out as the zero point for the system of stardates developed for Star Trek: The Next Generation, assuming that the beginning of year 2364 (the first season of Star Trek: The Next Generation) was stardate 41000, and that stardates progress at 1000 units per year. In other words, under the Next Generation system of stardates, January 1, 2323 would seem to correspond to stardate 0. This probably shouldn't be taken too seriously, because Star Trek's stardates have never been too internally consistent, but we're mentioning it here because it's kinda fun. (No, we don't know how these stardates relate to the stardates used in the original Star Trek series or the movies, nor do we know what stardates would have been for years between the movies and this point. See the Appendix I [Regarding stardates] for more information on stardates.)

As they said, "stardates have never been too internally consistent", which is why some speculate that stardate 41000 was in May or that there were less than 1000 units per year.  For instance, on the next page they say:

Editors' confession: In "Dark Page" (TNG), an entry in Lwaxana's journal dated stardate 30620.1 is established to be during the year in which she got married, 2328. Unfortunately, under the  Star Trek: The Next Generation system of stardates (which allocates 1,000 stardate units per year, and puts the beginning of the year 2364 at stardate 41000) the beginning of the year 2328 should be around stardate 5000.  Star Trek technical consultant (and Chronology co-author) Mike Okuda decided that a four-digit stardate would be confusing since this sounds like an Original Series number, so he arbitrarily picked 30620, even though it is not consistent with stardates used elsewhere in the show.

In "Appendix I: Regarding Stardates" they give more information, such as the fact that "As with the original series, an increase of a single unit within an episode corresponds to about 24 hours, even though this is inconsistent with a 365-day year."  They also relate a theory that stardates in The Original Series represented months and days from the beginning of a mission, so 1312 indicated thirteen months and twelve days, and 5928 was about five years, although there were plenty of stardates which would have more than 31 days, as in "Errand of Mercy", which took place between stardates 3198.4 and 3201.7.  Assuming 100-day months, that would be more than twelve years spread over 46 months.

In Star Trek 30 Years Special Collector's Edition, it states that Gene Roddenberry "borrowed the notion from the Julian date currently used by astronomers...Roddenberry borrowed the five-digit [Modified] Julian date, shortening it to four digits and renaming it 'stardate.'" I've long suspected that this was the case, due to the strong similarity, such as the subtle use of decimal time: "For Star Trek, Roddenberry added a single digit after the decimal point (50335.2, for example) to represent one of 10 time increments in a 24-hour period."

There was an earlier work, Star Trek Spaceflight Chronology by Stanley and Fred Goldstein, published the same month as Star Trek: The Motion Picture in 1979.  Based upon references in The Original Series, the show was set in the early 23rd century, 2207-2210.  In the 1980s FASA made a game called Star Trek: The Role Playing Game which used this Chronology.  They created "reference stardates" in the form C/YYMM.DD, where C is the century (actually the second digit of the year), YY is the last two digits of the year, MM is the month and DD the day, so January 1, 2000, was 0/0001.01, and the episode "Where No Man Has Gone Before" was 2/0705, or May 2207.  Stardates in the 1900s are negative, so this episode aired on -1/6609.22, which was also the day my sister was born.  Of course, this early Chronology was ignored when TNG was made, and TOS was then set to about 300 years after it was produced.

I posted last month about stardates in Star Trek Online.  With a bunch of math and experimentation, and with a little help from the webmaster of STO Academy, I figured out exactly how they work.

There are several stardate calculators online which do not all agree with each other. I recognized right off that STO's are almost the same as the TNG stardates on TrekGuide.com. This page was changed last year, but the archived page says:

there are exactly 1,000 Stardates per year...Stardate 00000.0 began on May 25, 2322, at 00:00 hours.

Subtract 400 years and you get the following STO stardates:

Stardate: 87000.00 Earthdate: 5/25/2009 12:00:00am UTC

Stardate: 88000.00 Earthdate: 5/25/2010 12:00:00am UTC

Stardate: 89000.00 Earthdate: 5/25/2011 12:00:00am UTC

Stardate: 90000.00 Earthdate: 5/24/2012 9:28:06am UTC

Wait, what? This threw me at first. This year is different from previous years. That is because it's a leap year, so instead of 365 days there are 366, but there are still exactly 1000.00 stardates from January 1 through December 31. That means that the stardates run a little slower than previous years, so instead of 2.74 per day there are 2.73, or about one second slower per 0.01 stardate.

The one thing that does stay constant is that every year starts on xx605.48:

Stardate: 87605.48 Earthdate: 1/1/2010 12:00:17am UTC

Stardate: 88605.48 Earthdate: 1/1/2011 12:00:17am UTC

Stardate: 89605.48 Earthdate: 1/1/2012 12:00:17am UTC

Stardate: 90605.48 Earthdate: 1/1/2013 12:00:17am UTC

That is because there are 221 days from May 25 to January 1, and 221/365 = 0.60548, even though it's a leap year. So with this information, you should be able to use stardates anywhere, not just in the game.

MJD 56154.199

STO 90226.24

FASA 0/1208.14

Update (56158.121): I should include an actual formula for Star Trek Online stardates:

1000×(day-of-year/length-of-year + year - 1923 + 221/365)

Where day-of-year is the number of days from January 1, including the time as a fractional day, found by dividing the hour by 24, e.g. January 2 at 12:00 UTC is 2.5.  Length-of-year is 365 in common years, 366 in leap years.  221 is the number of days from May 25 to the end of the year.  So for August 19, 2012 at 02:50:54 UTC: 1000×(232.11868/366 + 2012 - 1923 + 0.60548) = 90239.68.