> I'm trying to find out how many weekends there's between 2 dates and
> Googling I found this algorithm from
> http://archives.postgresql.org/pgsql-sql/2002-06/msg00304.php
>
> date := now - day_of_the_week
>> interval := interval + day_of_the_week
>> date := date + int( interval/5)x7 + ( interval mod 5)
I'm no math wizz, but:
I'd guess you would need to know the amount of days between start and end date
How many full weeks there are in there
And then add the weekend days that are located at the ends
So end date minus (total days mod 7)
with that information you can add (if needed another weekend or day)
If anyone has something better, please, do correct me!
HTH
Regards,
Serge Fonville