14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→now
m (→now) |
|||
| Line 7: | Line 7: | ||
** SELECT NOW(); /*return the human readable current time: 2011-04-01 12:19:43 */ | ** SELECT NOW(); /*return the human readable current time: 2011-04-01 12:19:43 */ | ||
** SELECT NOW()+0; //2011-04-01 12:19:43 returns 20110401122023.000000 | ** SELECT NOW()+0; //2011-04-01 12:19:43 returns 20110401122023.000000 | ||
** SELECT CURRENT_TIMESTAMP; | ** SELECT CURRENT_TIMESTAMP; /*return the human readable current time: 2011-04-01 12:19:43 */ | ||
the current '''timestamp''' ex: 1292897201 | the current '''timestamp''' ex: 1292897201 | ||