stamp ) < '7days'::interval;
>
> Frank
>
> At 09:07 AM 7/11/00 +0200, you wrote:
> >Hi Rob,
> >
> >Try this:
> >
> >select * from blah where stamp >= now()::date - 7;
> >
> >I think it should work.
> >
> >/Patrik Kudo
I think this is in the FAQ. I was reading it last nite and I believe
there's something in there that might be relevant.
- r
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> Of Volker Paul
> Sent: July 11, 2000 12:32 AM
> To: [EMAIL PROTECTED]
> Subjec
Hi all,
I would like to say,
"select * from blah where stamp >= 7 days ago"
...where the "days ago" is calculated at query time; meaning that its not
hardcoded into the query as a date string. Is this possible?
TIA! =)
- Rob Slifka
Thanks very much everyone!
> BTW, this *is* covered in the FAQ, see
> http://www.postgresql.org/docs/faq-english.html#4.22
Ahh, but I did look at a FAQ! I just went back and checked the date, I guess
I shouldn't have just skimmed down the page: Last updated: Mon Oct 14
08:05:23 EDT 1996.
As a precursor to this question, I read:
CREATE TABLE
Date/Time Types (and corresponding input/output)
Date/Time Functions
...but I still don't see how to have the default value of a timestamp to be
the time at which the individual record is inserted. I just get the time
