Home > mailing lists

Re: SQL Challenge: Skip Weekends - Mailing list pgsql-sql

From	Josh Berkus
Subject	Re: SQL Challenge: Skip Weekends
Date	June 21, 2002 20:01:45
Msg-id	web-1552104@davinci.ethosmedia.com Whole thread Raw
In response to	Re: SQL Challenge: Skip Weekends (Jean-Luc Lachance <jllachan@nsd.ca>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Jie Liang
Date: 21 June 2002, 19:57:10
Subject: FW: RESTORE A TABLE

From: "Josh Berkus"
Date: 21 June 2002, 20:21:20
Subject: Re: skip weekends

Re: SQL Challenge: Skip Weekends - Mailing list pgsql-sql

Previous

Next