Trying to use select statement using CURRENT_DATE
Which works fine like so:
select * from headlines where dateof = CURRENT_DATE order by dateof desc
But I'm also wanting to do something similar to:
select * from headlines where dateof = CURRENT_DATE - INTERVAL '1' DAY
order by dateof desc
Basically just trying to subtract 1 day from the CURRENT_DATE
When I try the above I get
ERROR: parser: parse error at or near "day"
Any suggestions would be appreciated.
Kevin
--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------