mysql获取当前毫秒数、0点9点24点的毫秒数

select UNIX_TIMESTAMP()

select UNIX_TIMESTAMP(CURRENT_TIMESTAMP(3)) 1000

或

select UNIX_TIMESTAMP(NOW(3)) 1000

3代表小数点后3位小数（也就到毫秒）

select unix_timestamp(CURDATE())*1000

SELECT unix_timestamp(DATE_ADD(CURDATE(), INTERVAL 9 HOUR))*1000

SELECT DATE_ADD(CURDATE(), INTERVAL 24 HOUR)

如果算毫秒数就unix_timestamp，再*1000

SELECT DATE_SUB(CURDATE(),INTERVAL 1DAY)

如果算毫秒数就unix_timestamp，再*1000

select time_to_sec(now()), now(),

current_timestamp(),

replace(unix_timestamp(now(3)),'.',''),

replace(unix_timestamp(current_timestamp(3)),'.',''),

replace(current_timestamp(3),'.',':'),

unix_timestamp(current_timestamp(3)),

unix_timestamp()

---