mysql函数-FROM_UNIXTIME

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