"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
ofdays in the month. I think you'll have to calculate that (for February) the hard way :-P You *do* know the
algorithmfor testing if year yyyy is a leap year, don't you? ((yyyy%4) && !(yyyy%400))
Allan.
