am Fri, dem 27.04.2007, um 8:18:55 +0100 mailte Peter Childs folgendes:
> >Sure, that's an alternative, but it seems a bit too much reinventing an
> >already existing wheel. I was amused to see the script had the ill-fated
> >Lee-Jackson-King day in it. Ideally, we'd want a Postgres table that
>
On 26/04/07, Greg Sabino Mullane <[EMAIL PROTECTED]> wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> However, you quickly run into the problem of holidays. While you
>> could construct a helper table listing all the holidays, ones that
>> don't fall on the same day every year (e.g
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> However, you quickly run into the problem of holidays. While you
>> could construct a helper table listing all the holidays, ones that
>> don't fall on the same day every year (e.g. Easter) will trip
>> you up.
> Er, isn't Easter usually on
- -- I need to get the a total number of business days (from monday to
- -- friday) between two dates.
- -- Someone can help me please.
A simplistic approach that counts a "business day" as being Monday
through Friday would be something like this:
However, you quickly run into the problem of h
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
- -- I need to get the a total number of business days (from monday to
- -- friday) between two dates.
- -- Someone can help me please.
A simplistic approach that counts a "business day" as being Monday
through Friday would be something like
am Wed, dem 25.04.2007, um 21:01:13 -0400 mailte Eddy D. Sanchez folgendes:
> Hello...
> I need to get the a total number of business days (from monday to
> friday) between two dates.
> Someone can help me please.
For instance the number of business days between 2007-04-01 and
2007-04-30:
sele
Eddy D. Sanchez wrote:
Hello...
I need to get the a total number of business days (from monday to
friday) between two dates.
Someone can help me please.
Whether you're using PHP or not, this page may be of some help:
http://www.php.net/manual/en/function.date.php
There are a couple of exa
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.
