select NOW()::date "2010-04-23"
select t_date from table where t_date >= NOW()::date+'1 day'::interval order by t_date limit 3"2010-04-24"
"2010-04-24"
"2010-04-24"
select t_date from table where t_date >= NOW()+'1 day'::interval order by t_date limit 3"2010-04-25"
"2010-04-25"
"2010-04-25"
select * from table where t_add_date < NOW()-'5 MONTH'::interval
select * from table where t_add_date < NOW()+'5 MONTH'::interval
select * from table where t_add_date < NOW()-'1 DAY'::interval
select * from table where t_add_date < NOW()-'2 DAYS'::interval
select * from table where t_add_date < NOW()-'1 DAY'::interval
select * from table where t_add_date < NOW()-'5 MINUTES'::interval
select * from table where t_add_date < NOW()-'3 HOURS'::interval