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
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