select FROM_UNIXTIME(1464973385.641,'%Y-%m-%d %H:%i:%s');
select UNIX_TIMESTAMP('2016-06-04 01:03:05');

结果:
FROM_UNIXTIME(1464973385.641,'%Y-%m-%d %H:%i:%s')
2016-06-04 01:03:05

UNIX_TIMESTAMP('2016-06-04 01:03:05')
1464973385

 

 

posted on 2016-06-10 10:41  vinsonLu  阅读(24647)  评论(0编辑  收藏  举报