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 setmysql> select from_unixtime(unix_timestamp());+---------------------------------+| from_unixtime(unix_timestamp()) |+---------------------------------+| 2017-11-12 15:57:43             |+---------------------------------+1 row in setmysql> select from_unixtime(unix_timestamp(), '%Y-%m-%d');+---------------------------------------------+| from_unixtime(unix_timestamp(), '%Y-%m-%d') |+---------------------------------------------+| 2017-11-12                                  |+---------------------------------------------+1 row in set