[development] no date / time types in schema API

Olivier Jacquet ojacquet at jax.be
Fri Jul 4 19:30:30 UTC 2008


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.


David Timothy Strauss wrote:
> ----- "augustin (beginner)" <drupal.beginner at 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.

More information about the development mailing list