Thread: Select last week

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@hank.org
Sent from my iMutt