PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
the current time ex: 2010-12-21 10:05:06 | the human readable current time ex: 2010-12-21 10:05:06 | ||
* php: echo date("y-m-d H:i:s", time()); | * php: echo date("y-m-d H:i:s", time()); | ||
* mysql: SELECT NOW(); | * mysql: SELECT NOW(); | ||
Revision as of 14:57, 15 March 2011
the human readable current time ex: 2010-12-21 10:05:06
- php: echo date("y-m-d H:i:s", time());
- mysql: SELECT NOW();
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');