It's great working with the Intelligent Design people, you don't have to worry about dates before 6000 BC. What a relief. Save all those zeros.
:-) ed On 12/7/06, Kenneth Downs <[EMAIL PROTECTED]> wrote:
tedd wrote: > On Mon, Dec 04, 2006 at 11:06:27AM -0500, Phil Duffy wrote: >> I understand that MySQL does not have the ability to store B.C. >> dates, but >> that PostgreSQL does. > > Considering the history of calendars, I wonder how they did that? > > It's one thing to estimate that 2000 years ago was 0006 -- but, it's a > completely different thing to claim that 2000 years ago today was > December 7, 0006. > > Cheers, > > tedd One of Joe Celko's books gives a pretty thorough run-down of the variations that have to be accommodated, including such things as the days that happened more than once and the days that never happened, and so forth. Compared to what's happened in AD-land, the BC stuff is easy :) _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
-- the Blog: http://www.utopiaparkway.com the Karma: http://www.coderswithconscience.com the Projects: http://flickr.com/photos/[EMAIL PROTECTED]/ the Store: http://astore.amazon.com/httpwwwutopic-20 _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
