Where year(日期字段)=year(date()) and month(日期字段)=month(date()) and day(日期字段)=day(date())

不用写rq=date()