[development] no date / time types in schema API

[David Strauss]

And no, the UNIX epoch is always relative to Jan 1, 1970 00:00 UTC.

-----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


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 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.
>