使用PHP存储时间戳：date（）或MySQL：FROM_UNIXTIME（）？

Question

This may be trivial, but when I want to store a timestamp value (returned by, say, time()) into a TIMESTAMP column in my MySQL table, which of these two are preferable:

function storeTime($timestamp) {
   // Option one:
   $query = "INSERT INTO faketable (datecol) VALUES (FROM_UNIXTIME(".$timestamp."))";
   // Option two:
   $query = "INSERT INTO faketable (datecol) VALUES (".date("YY-MM-DD HH:MM:II", $timestamp).")";
}

Is there even a difference?

EDIT: Sorry, meant date(), not strtotime()...

EDIT 2: NOW() doesn't cut the mustard, the actual timestamp is a paramater sent to my method. I don't know what it is in advance.

EDIT 3: I really shouldn't be asking questions at this time of night. The column in question is, in fact, a TIMESTAMP column, not a DATETIME column.

Answer 1

To answer your question; No there is no logical difference. They both return a string representation of a date https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_from-unixtime, which MySQL will happily convert to a DATETIME, or TIMESTAMP type. As for which is faster evidence would suggest MySQL; http://www.onextrapixel.com/2010/06/23/mysql-has-functions-part-5-php-vs-mysql-performance/, Faster to use MySQL's CURDATE() or PHP's date()?