You forget: * Negative numbers * That we've even discussed such negative numbers in this thread -----Original Message----- From: Olivier Jacquet <ojacquet@jax.be> Date: Fri, 04 Jul 2008 21:30:30 To: <development@drupal.org> Subject: Re: [development] no date / time types in schema API David, Read up on "Unix Epoch". The unix timestamp 0 corresponds to January 1, 1970. So it's rather difficult to represent a date before that year. Also, implementations do or do not take timezones into account wich makes it even more difficult. Regards, Olivier David Timothy Strauss wrote:
----- "augustin (beginner)" <drupal.beginner@wechange.org> wrote:
On Wednesday 02 July 2008 18:36:15 Damien wrote:
A solution based on timestamps is much more elegant: timestamps need no (database-specific) parsing whatsoever (both on reading and writing to the database), they play nice with arithmetic (and thus do not need any helper functions), and are consistent with the implementation of most application, including Drupal. How do you use a timestamp when you need the date 18 Aug 1908 on a date field???
You use the UNIX timestamp at 00:00 UTC that day.