[fw-general] Zend_Db and Dates

[Jack Sleight]

Hi,
Two questions, the first is what do people think is the best way to 
store dates in a MySQL database, for speed/efficiency and convenience? 
Typically I've always used timestamps, simply because PHP uses them so 
much, but seeing as Zend_Date uses the ISO standard date format, so it's 
free of the limitations of timestamps, it doesn't make much sense for me 
to impose the timestamp limitations on the database, an it would 
certainly be easier to work with when looking directly at the DB tables. 
Can you still easily do date comparisons (greater/less than etc) in the 
SQL when the fields a date/time type?

My second question is does Zend_Db_Table have any built in facility for 
automatically setting date_created and date_modified fields in the 
table, and if so how do I configure this. If not, is it easy enough to 
add myself? I want something that's pretty much automated.

Thanks!
--
Jack