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