On Thu, Feb 26, 2004 at 03:07:52AM -0000, Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> > How to find the last sunday/mon..../sat of any given month.
> There is probably a smoother way to do it, but here is a
> quick little function to do what you ask. Feed it a date
> and a number, where 0 is Sunday, 1 is Monday, etc.
select date_trunc('month', current_date + '1 month'::interval) - '1 day'::interval +
(((3 - 7 - to_char(date_trunc('month', current_date + '1 month'::interval) -
'1 day'::interval,'D')::int) %7)||' days')::interval;
The "3" is the day of week (1 = Sunday, 7 = Saturday). This equation
will return the date of the last "x" of the current month. Change
"current_date" to be whatever date you wish to find the last "x" of.
Michael Darrin Chaney
In response to
pgsql-sql by date
|Next:||From: Kumar||Date: 2004-02-27 04:51:31|
|Subject: Re: Return more than a record|
|Previous:||From: Leo Leo||Date: 2004-02-26 15:58:28|
|Subject: a few Questions about quoted varaibles in psql|