Re: First Saturday and Last Saturday of a month

"Brian C. Doyle" wrote:

> Hello all,
>
> I have a Function that gives me the fsunday of a week Based on the date you
> give it the select looks like
> SELECT Date('now') - timespan( text( date_part( 'dow', Date('now') ) ) ||
> 'days' )
> and if you run that today you will get
> ?column?
> ------------------------
> 2001-08-05 00:00:00-04
> (1 row)
>
> Which is what I want it to do ...
>
> Now I need to setup a function that will give me the first Saturday of the
> month and then one to get the Last Saturday of the month.

It's too late to hack code, but:

For the first Saturday problem assign

select date_part('dow', 'yyyy-mm-01'::DATE);

to a variable x. Here yyy and mm is the year and month you are interested in. The day you want is 'yyyy-mm-01' + [(6-x) days].

Getting all the conversions right is left as an exercise for the reader :-)

Last Saturday problem is similar to above except for some sign reversals, but more interesting as you need the number of days in the month. I think you'll have to calculate that (for February) the hard way :-P You *do* know the algorithm for testing if year yyyy is a leap year, don't you? ((yyyy%4) && !(yyyy%400))

Allan.