SELECT FROM_UNIXTIME(1394550000000/1000,'%Y-%m-%d %h:%i:%s') AS DATE ;
其中: 1394550000000 是毫秒值
结果: 2014-03-11 11:00:00
转载于:https://my.oschina.net/huiger/blog/207574
SELECT FROM_UNIXTIME(1394550000000/1000,'%Y-%m-%d %h:%i:%s') AS DATE ;
其中: 1394550000000 是毫秒值
结果: 2014-03-11 11:00:00
转载于:https://my.oschina.net/huiger/blog/207574