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