mysql 获取当前时间为select now()
运行结果:
2017-04-15 05:24:05

mysql 获取当前时间戳为select unix_timestamp(now()) 
运行结果:
unix_timestamp(now())
1556555555
 
SELECT FROM_UNIXTIME(1234567890);
SELECT FROM_UNIXTIME(1234567890, '%Y-%m-%d %H:%i:%S')