grabbing date of last Sunday?

From: "blackwater dev" <blackwaterdev(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: grabbing date of last Sunday?
Date: 2008-10-10 15:29:53
Message-ID: 34a9824e0810100829x74617636idae0933ec98e14d4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How can I grab the date from the last Sunday based on when I run the query?

For example I run it today, and I need to date of 10-5-08, if I ran it next
week, I would want 10-12-08, etc.

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2008-10-10 15:36:29 Re: grabbing date of last Sunday?
Previous Message Bill Thoen 2008-10-10 15:26:04 Bug In COPY TO?