SQL根据date查询出String类型的日期、时间、星期 SELECT DATE_FORMAT(NOW(),'%Y-%m-%d') as date; SELECT DATE_FORMAT(NOW(),'%H:%i') as time; SELECT DATE_FORMAT(NOW(),'%w') as week;