sql语句:
SELECT
TIME_TO_SEC(NOW()),
NOW(),
current_timestamp(),
REPLACE(unix_timestamp(current_timestamp(3)),'.','');
执行结果:
优化版
SELECT
TIME_TO_SEC(NOW()),
NOW(),
current_timestamp(),
REPLACE(unix_timestamp(NOW(3)),'.',''),
REPLACE(unix_timestamp(current_timestamp(3)),'.',''),
current_timestamp(3),
unix_timestamp(current_timestamp(3));
最后一个,就是你想要的系统毫秒数了
获取已知日期的时间毫秒数
select UNIX_TIMESTAMP(system_create_date)*1000 from table