unix_timestamp / from_unixtime
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
MariaDB [mysql]> select unix_timestamp('2015-12-01'); +------------------------------+ | unix_timestamp('2015-12-01') | +------------------------------+ | 1448895600 | +------------------------------+ MariaDB [mysql]> select from_unixtime('1417359600'); +-----------------------------+ | from_unixtime('1417359600') | +-----------------------------+ | 2014-12-01 00:00:00 | +-----------------------------+ |