Re: Geologic Time

2005-02-28 Thread David Blomstrom
Peter Brawley wrote, "The earliest possible MySQL date is around 1000CE, so you could not store geologic dates in MySQL date cols. "Million years before present" is the geologic time unit that would most likely cohere with other geo databases, isn't it? Then the Cambrian woul

Re: Geologic Time

2005-02-28 Thread Peter Brawley
David, The earliest possible MySQL date is around 1000CE, so you could not store geologic dates in MySQL date cols. "Million years before present" is the geologic time unit that would most likely cohere with other geo databases, isn't it? Then the Cambrian would show up arou

Re: Geologic Time

2005-02-28 Thread Gary Richardson
gt; wrote: > I'm working on a geologic time database and want to > ask a question about geologic time. Can/should you > apply MySQL's date function to geologic time? > > In other words, if I create a field for the number of > years ago a certain geologic period began or

Geologic Time

2005-02-28 Thread David Blomstrom
I'm working on a geologic time database and want to ask a question about geologic time. Can/should you apply MySQL's date function to geologic time? In other words, if I create a field for the number of years ago a certain geologic period began or ended - say 260 million years ago