I have to store epoch timestamps into a MySQL database DateTime column. I need to be able to convert the epoch into the DateTime form to be able to add it to the database. The epoch data is grabbed from an external source so we have no control over that, the database is also established and should be left as it is. We just need to be able to convert between the two in PHP.
1
-
There're many epochs... I presume you mean Unix epoch :-?Álvaro González– Álvaro González2015-12-10 10:52:05 +00:00Commented Dec 10, 2015 at 10:52
Add a comment
|
3 Answers
PHP
date("Y-m-d H:i:s",$epochTS);
MySQL
FROM_UNIXTIME(timestampColumn)
Nothing more to it
1 Comment
Peter Bushnell
Many thanks, the PHP you have expresses the date exactly as it is in the database,
No need to do any convert for MySQL or PHP just or enter the same to database
echo date('r', $epoch);
strotime() is the function used to convert datetime to epoch. Documentation
Comments
strotime() is the function used to convert datetime to epoch. Documentation
time() is the function used to convert epoch to datetime. Documentation
