Re: Business days

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Business days
Date: 2007-04-26 01:41:47
Message-ID: Pine.LNX.4.64.0704251841001.16658@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-04-26 02:52:49 Re: Feature request - have postgresql log warning when new sub-release comes out.
Previous Message brian 2007-04-26 01:10:08 Re: Business days