now() //当前时间
unix_timestamp() //当前时间戳,也可以把当前时间转化成时间戳
from_unixtime(1533657600) //将时间戳转换为时间 默认格式 ‘%Y-%m-%d %H:%i:%s’
SELECT state, DATE_FORMAT(FROM_UNIXTIME(ctime),"%Y-%m-%d") as day FROM jshop_user_log
mysql 数据格式化
格式化后
SELECT id,FORMAT(amount/100,2) as amount FROM think_bank_bill WHERE id =23