Mega Code Archive

 

Categories / MySQL / Date Time

 

FROM_UNIXTIMEUNIX_TIMESTAMP

estamps: mysql> mysql> mysql> SELECT NOW(), UNIX_TIMESTAMP(NOW()); +---------------------+-----------------------+ | NOW()               | UNIX_TIMESTAMP(NOW()) | +---------------------+-----------------------+ | 2011-10-03 10:22:37 |            1317666157 | +---------------------+-----------------------+ 1 row in set (0.00 sec) mysql>