Postgres Pro
Downloads
Home   >   mailing lists

Date for a week day of a month - Mailing list pgsql-general

From Emi Lu
Subject Date for a week day of a month
Date
Msg-id 468A950C.9000405@encs.concordia.ca
Whole thread Raw
Responses Re: Date for a week day of a month  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Date for a week day of a month  (Nick Barr <nicky@chuckie.co.uk>)
Re: Date for a week day of a month  (Michael Glaesemann <grzm@seespotcode.net>)
Re: Date for a week day of a month  ("hubert depesz lubaczewski" <depesz@gmail.com>)
List pgsql-general
Tree view 
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!

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: What O/S or hardware feature would be useful for databases?
Next
From: Charles Pare
Date:
Subject: Stored Procedure: Copy table from; path = text variable