使用数据库有时候会遇到时间戳和正常date的转换 这里记录一下
时间戳转换为正常date格式时间
mysql> select from_unixtime(1502974800);
+---------------------------+
| from_unixtime(1502974800) |
+---------------------------+
| 2017-08-17 21:00:00 |
+---------------------------+
转为时间戳
mysql> select unix_timestamp('2017-08-17 21:00:00');
+---------------------------------------+
| unix_timestamp('2017-08-17 21:00:00') |
+---------------------------------------+
| 1502974800 |
+---------------------------------------+
1 row in set (0.00 sec)