用PHP提取服务器时间并存储在MySQL中 - Unix时间戳好吗？

Question

All,

I'm trying to decide how to deal with time in a project which relies on (server) time intervals (in short, some content is available after user completed a specific action at least n hours before). Right now, it seems like the easiest option would be to extract the Unix time stamp with time() and store it as is in MySQL.

Any reason why this is not a good idea? Any gotcha I need to be aware of? Performance impact?

Answer 1

Seems fine to me. Though you should probably store it as a DATETIME and use DateTime objects, rather than UNIX timestamps and time().

$time = new DateTime;
echo $time->format("Y-m-d H:i:s"); //Outputs current time, example: 2012-10-13 22:58:34