[development] no date / time types in schema API

David Strauss david at fourkitchens.com
Fri Jul 4 23:20:03 UTC 2008

You forget:
* Negative numbers
* That we've even discussed such negative numbers in this thread

-----Original Message-----
From: Olivier Jacquet <ojacquet at jax.be>

Date: Fri, 04 Jul 2008 21:30:30 
To: <development at drupal.org>
Subject: Re: [development] no date / time types in schema API


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