Weekends between

From: Luiz Eduardo Cantanhede Neri <lecneri(at)gmail(dot)com>
To: postgresql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Weekends between
Date: 2009-07-30 14:40:01
Message-ID: 252e1f290907300740s22e1d2ffle858304152bb2a2f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi guys,

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)

Assuming that now is current datetime, what I should expect from a
date - int? or some1 could explain it better please?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Serge Fonville 2009-07-30 14:50:12 Re: Weekends between
Previous Message Andreas Wenk 2009-07-29 11:22:15 Re: trouble with connection