Home > mailing lists

grabbing date of last Sunday? - Mailing list pgsql-general

From	blackwater dev
Subject	grabbing date of last Sunday?
Date	October 10, 2008 15:30:06
Msg-id	34a9824e0810100829x74617636idae0933ec98e14d4@mail.gmail.com Whole thread Raw
Responses	Re: grabbing date of last Sunday? (Raymond O'Donnell <rod@iol.ie>)
List	pgsql-general

Tree view

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!

pgsql-general by date:

From: Bill Thoen
Date: 10 October 2008, 15:26:17
Subject: Bug In COPY TO?

From: Raymond O'Donnell
Date: 10 October 2008, 15:36:43
Subject: Re: grabbing date of last Sunday?

grabbing date of last Sunday? - Mailing list pgsql-general

Previous

Next