Selecting rows where timestamp between two timestamps

[Jeff Lanzarotta <delux256-postgresql@xxxxxxxxx>]

Hello,

I am trying to get this query to work with no luck...


select * from foobar where ts between now() and now() - interval '5 days'


btw, the column ts is defined as:

ts timestamp with time zone NOT NULL DEFAULT now()

No rows are returned, but I know there are at least 100 rows that should be returned...

Any ideas?

Thanks.


-Jeff