sql语句当前时间查询 select oper_time from gx_depot_head where YEAR(h.oper_time) LIKE YEAR(NOW()) 查询当前年和sql字段对用的时间 MONTH(字段) like MONTH(NOW()) WEEK(字段) like WEEK(NOW())