Date: 03/15/05 (MySQL Communtiy)    Keywords: php, mysql, database, sql

I'm working on a database table and am having trouble getting the dates added properly. I want two date fields, one to store the date the record was created, the other to store the date it was last modified. However, I can't figure out how to get the fields to hold anything but a bunch of zeros. I've tried TIMESTAMP and DATETIME and using the PHP time function and reading through the mysql.com documentation and am still in the dark. Any help would be appreciated.

Source: http://www.livejournal.com/community/mysql/50849.html