NOW()
示例:
select * from users where date<now()
INTERVAL '7' DAY
select * from users where date<now()-INTERVAL '7' DAY
to_date(to_char(x, 'yyyy-MM-dd'),'yyyy-MM-dd')