From: John N Joyner <jnj@...>
Date: 2007-07-11T10:36:59+09:00
Subject: Best MySQL date/time data type when using Ruby?

In the years when I used PHP to develop web apps, I found either a MySQL
TIMESTAMP or an integer of the same value was most convenient for
storing date/time information and then converting back and forth using
PHP functions.

Now that I'm using Ruby, I'm wondering whether the MySQL DATETIME type
might be a better match with the Ruby Date class and its methods, based
on looking at the Date class documentation. I'd be interested to know
whether Rubyists who use MySQL mostly use the DATETIME data type or the
TIMESTAMP data type? (I'm not using ROR, though I have nothing against
it.)

Any input much appreciated.
--
John N Joyner
Ruby, MySQL, Pair Networks