PHP and MySQL syntax

the 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');

---

• PHP Date and Time functions
• MySQL The DATETIME, DATE, and TIMESTAMP Types
• MySQL Date and Time Functions