Hi,
just make it a TIMESTAMP field.
One of the good things about it is that if you do not explicitely it, it will be autmatically filled with the current time. Note that a MySQL timestamp is not a Unix Timestamp!
Regards,
svenXY
Comment on Re: calculating 24 hours ago with localtime
Whenever I have to work with MySQL, I avoid TIMESTAMP like the plague. I initially thought it was a bug, but
it seems to be a "feature" to update the first TIMESTAMP column on an update (or insert).