mysql函数-FROM_UNIXTIME
将一个unix_timestamp时间戳转成日期字符串
用法:
FROM_UNIXTIME(unix_timestamp), FROM_UNIXTIME(unix_timestamp,format)
如果第二个参数format不为空,则转成format日期格式的字符串
mysql> select from_unixtime(1111860000);
+---------------------------+
| from_unixtime(1111860000) |
+---------------------------+
| 2005-03-27 02:00:00 |
+---------------------------+
1 row in set
mysql> select from_unixtime(unix_timestamp());
+---------------------------------+
| from_unixtime(unix_timestamp()) |
+---------------------------------+
| 2017-11-12 15:57:43 |
+---------------------------------+
1 row in set
mysql> select from_unixtime(unix_timestamp(), '%Y-%m-%d');
+---------------------------------------------+
| from_unixtime(unix_timestamp(), '%Y-%m-%d') |
+---------------------------------------------+
| 2017-11-12 |
+---------------------------------------------+
1 row in set