Re: Business days - Mailing list pgsql-general

From Rich Shepard
Subject Re: Business days
Date
Msg-id Pine.LNX.4.64.0704251841001.16658@salmo.appl-ecosys.com
Whole thread Raw
In response to Business days  ("Eddy D. Sanchez" <eddy.sanchez@gmail.com>)
List pgsql-general
On Wed, 25 Apr 2007, Eddy D. Sanchez wrote:

> I need to get the a total number of business days (from monday to friday)
> between two dates. Someone can help me please.

   Joe Celko's "SQL for Smarties, 2nd Edition" has exactly this solution.
Check it out!

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

pgsql-general by date:

Previous
From: "Eddy D. Sanchez"
Date:
Subject: Business days
Next
From: brian
Date:
Subject: Re: Business days