14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→convert the unix timestamp to human readable time format
(→timer) |
|||
| Line 97: | Line 97: | ||
==== convert the unix timestamp to '''human readable''' time format ==== | ==== convert the unix timestamp to '''human readable''' time format ==== | ||
ex: 2010-12-21 10:05:06 | ex: 2010-12-21 10:05:06 | ||
* [http://www.epochconverter.com/ Epoch Converter - Unix Timestamp Converter] | |||
* PHP: echo date("Y-m-d H:i:s", 1292897201 ); // Using [http://us3.php.net/manual/en/function.date.php date()] function that converting the time stamp 1292897201 to the human readable time format. similar: [http://us3.php.net/gmdate gmdate()] function {{access | date = 2014-04-30}} {{exclaim}} server timezone dependent | * PHP: echo date("Y-m-d H:i:s", 1292897201 ); // Using [http://us3.php.net/manual/en/function.date.php date()] function that converting the time stamp 1292897201 to the human readable time format. similar: [http://us3.php.net/gmdate gmdate()] function {{access | date = 2014-04-30}} {{exclaim}} server timezone dependent | ||
* MySQL: | * MySQL: | ||