1、现在时间
NOW()
示例:
select * from users where date<now()
2、时间相减
INTERVAL '7' DAY
示例:
select * from users where date<now()-INTERVAL '7' DAY
3、timestamp转换为date类型
to_date(to_char(x, 'yyyy-MM-dd'),'yyyy-MM-dd')
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')