【MySQL】 UNIX时间戳与日期相互转换
1、日期转换为UNIX时间戳
1 2 3 4 5 6 7 8 9 |
mysql> SELECT unix_timestamp(now()),now(); +-----------------------+---------------------+ | unix_timestamp(now()) | now() | +-----------------------+---------------------+ | 1536918272 | 2018-09-14 17:44:32 | +-----------------------+---------------------+ 1 row in set (0.00 sec) mysql> |
2、UNIX时间戳转换为日期
1 2 3 4 5 6 7 8 9 |
mysql> select FROM_UNIXTIME(1536918272); +---------------------------+ | FROM_UNIXTIME(1536918272) | +---------------------------+ | 2018-09-14 17:44:32 | +---------------------------+ 1 row in set (0.00 sec) mysql> |