PHP and MySQL syntax
Jump to navigation
Jump to search
the human readable time format ex: 2010-12-21 10:05:06
- php:
- echo date("y-m-d H:i:s", time() ); //the human readable current time ex: 2010-12-21 10:05:06
- echo date("y-m-d H:i:s", 1292897201 ); // convert the time stamp 1292897201 to the human readable time format
- mysql: SELECT NOW(); /*the human readable current time */
the current timestamp ex: 1292897201
- php: echo time();
- mysql: SELECT NOW()+0;
time difference of two time values
- php: using mktime() function
- mysql: SELECT TIMEDIFF('2010:01:01 00:00:00', '2010:02:01 00:00:00');