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 around 580 mya, the
beginning of recorded human history around .005 mya, &c. A float, double
or decimal col would handle such values.
David Blomstrom 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 ended -
>say 260 million years ago - could I designate that
>I'll probably just designate a varchar field and enter
>data like this:
>Then I can add "million years ago" or "mya" in my PHP
>script. Some scientists also use the term BP ("Before
>Present," I think).
>Another thing I have to deal with is units of
>thousands. For example, the Pleistocene Epoch (Ice
>Age) ended about 10,000 years ago.
>I just wondered if anyone had any suggestions for
>dealing with geologic time. Thanks.
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.5.2 - Release Date: 2/28/2005