Обсуждение: Selecting rows where timestamp between two timestamps
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
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
On Mon, Aug 13, 2007 at 07:16:30AM -0700, Jeff Lanzarotta wrote: > 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... Put the lower value first or use BETWEEN SYMMETRIC: select * from foobar where ts between now() - interval '5 days' and now() select * from foobar where ts between symmetric now() and now() - interval '5 days' -- Michael Fuhr
Well that was easy enough... Thanks!
Michael Fuhr <mike@fuhr.org> wrote:
Michael Fuhr <mike@fuhr.org> wrote:
On Mon, Aug 13, 2007 at 07:16:30AM -0700, Jeff Lanzarotta wrote:
> 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...
Put the lower value first or use BETWEEN SYMMETRIC:
select * from foobar where ts between now() - interval '5 days' and now()
select * from foobar where ts between symmetric now() and now() - interval '5 days'
--
Michael Fuhr