Greg Sabino Mullane wrote:
>>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.
oops...forget my last reply...I was a bit too quick on the draw. Try
regression=# select date_trunc('month', current_date + '1
month'::interval) - '1 day'::interval;
In response to
pgsql-sql by date
|Next:||From: Sumita Biswas (sbiswas)||Date: 2004-02-26 05:51:12|
|Subject: Unicode Support|
|Previous:||From: Joe Conway||Date: 2004-02-26 04:27:57|
|Subject: Re: Last day of month|