[development] no date / time types in schema API

[Jonathan Hedstrom]

augustin (beginner) 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???
>
> Augustin.
>
>   
Just to clarify, there is a significant difference between most DB
implementations of a timestamp [1,2] and a unix timestamp [3].

1. http://dev.mysql.com/doc/refman/5.0/en/timestamp.html
2. http://www.postgresql.org/docs/8.3/static/datatype-datetime.html
3. http://us3.php.net/manual/en/function.time.php

-- 
Jonathan Hedstrom                                     OpenSourcery
http://opensourcery.com                        Technology for Good


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
Url : http://lists.drupal.org/pipermail/development/attachments/20080702/555981b9/attachment-0001.pgp