15,047
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→now
(→now) |
m (→now) |
||
| Line 15: | Line 15: | ||
* EXCEL: [http://stackoverflow.com/questions/1703505/excel-date-to-unix-timestamp Excel date to Unix timestamp - Stack Overflow] | * EXCEL: [http://stackoverflow.com/questions/1703505/excel-date-to-unix-timestamp Excel date to Unix timestamp - Stack Overflow] | ||
compare the timestamp and human readable time format | compare the timestamp and human readable time format using MySQL | ||
SELECT UNIX_TIMESTAMP( ) , FROM_UNIXTIME( UNIX_TIMESTAMP( ) , '%Y-%m-%d %H:%i:%S' ); | SELECT UNIX_TIMESTAMP( ) , FROM_UNIXTIME( UNIX_TIMESTAMP( ) , '%Y-%m-%d %H:%i:%S' ); | ||