(1)当前时间 select now(); 输出:2015-04-17 18:50:03; (2)unix时间戳转换为日期时间格式 SELECT FROM_UNIXTIME( start_hour, '%Y%m%d %H:%i' ) as start,FROM_UNIXTIME( end_hour, '%Y%m%d %H:%i' ) as end from shopgoo_appointment_t;