Re: SQL Challenge: Skip Weekends

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>, josh(at)agliodbs(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL Challenge: Skip Weekends
Date: 2002-06-21 19:29:27
Message-ID: web-1552104@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jean-Luc,

> date := now - day_of_the_week
> interval := interval + day_of_the_week
> date := date + int( interval/5)x7 + ( interval mod 5)

Merci, merci, merci!

-Josh

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-06-21 19:31:23 Re: SQL Challenge: Skip Weekends
Previous Message Oleg Lebedev 2002-06-21 18:59:32 index problem