From: | Bill Moseley <moseley(at)hank(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Select last week |
Date: | 2009-06-06 14:03:56 |
Message-ID: | 20090606140355.GA15026@hank.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm looking at ways to select rows with a timestamp column of "last
week" relative to the current server time.
In 8.3 there's "isoyear" so is this a good approach?
extract( isoyear from foo_time )
= extract( isoyear from now() - interval '1 week' )
AND
extract( week from foo_time )
= extract( week from now() - interval '1 week' )
What about before isoyear was available in Postgresql?
Find the week and then add a week for the range?
date_trunc( 'second', foo_time ) BETWEEN
date_trunc( 'week', now() - interval '1 week' )
AND
date_trunc( 'week', now() - interval '1 week' )
+ interval '1 week' - interval '1 second'
Is there a better approach?
--
Bill Moseley
moseley(at)hank(dot)org
Sent from my iMutt
From | Date | Subject | |
---|---|---|---|
Next Message | Nykolyn, Andrew P (AS) | 2009-06-06 14:30:12 | Upgrade from Postgres 8.2.4 to 8.3.5 |
Previous Message | DimitryASuplatov | 2009-06-06 13:37:20 | Re: How to store text files in the postgresql? |