Quick Links

Date for a week day of a month

From:	Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To:	pgsql-sql-owner(at)postgresql(dot)org, pgsql general list <pgsql-general(at)postgresql(dot)org>
Subject:	Date for a week day of a month
Date:	2007-07-03 18:27:24
Message-ID:	468A950C.9000405@encs.concordia.ca
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hello,

Can I know how to get the date of each month's last Thursday please?

For example, something like

Query: select getDateBaseOnWeekday('2007-04-01', 'Last Thursday');
Result: 2007-04-26

Thank you!

Responses

Re: Date for a week day of a month at 2007-07-03 19:05:27 from A. Kretschmer
Re: Date for a week day of a month at 2007-07-03 19:17:11 from Nick Barr
Re: Date for a week day of a month at 2007-07-03 19:45:42 from Michael Glaesemann
Re: Date for a week day of a month at 2007-07-04 08:58:01 from hubert depesz lubaczewski

Browse pgsql-general by date

	From	Date	Subject
Next Message	Charles Pare	2007-07-03 18:49:48	Stored Procedure: Copy table from; path = text variable
Previous Message	Merlin Moncure	2007-07-03 18:03:53	Re: What O/S or hardware feature would be useful for databases?