mysql 获取当前时间戳

ysql 获取当前时间为select now()
运行结果2012-09-05 17:24:15
mysql 获取当前时间戳为select unix_timestamp(now()) 
运行结果：
unix_timestamp(now())
1346836984

-- 时间戳 2018-08-09
SELECT CURDATE();
-- 2018-08-09 11:16:03
SELECT now();
-- 1533785492
select unix_timestamp(now());
-- 1533744000
select unix_timestamp(CURDATE());

来源:https://blog.csdn.net/liangdsh/article/details/52438947