Postgres Pro
Downloads
Home   >   mailing lists

Selecting rows where timestamp between two timestamps - Mailing list pgsql-general

From Jeff Lanzarotta
Subject Selecting rows where timestamp between two timestamps
Date
Msg-id 814099.51287.qm@web36814.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Selecting rows where timestamp between two timestamps  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: TimestampTZ
Next
From: "Terri Reid"
Date:
Subject: non superuser creating flat files