From: Peter Brawley
Date: August 25 2005 2:09pm
Subject: Re: UK Bank Holidays
List-Archive: http://lists.mysql.com/mysql/188311
Message-Id: <430DD126.5000509@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Shaun

 >Is MySQL aware of UK Bank Holidays

Nope.

 > or do I have to create a separate table
 >and keep it updated with Bank Holiday dates?

Yep.

PB

-----

Shaun wrote:

>Hi,
>
>I need to work out number of business days worked by staff in our company 
>i.e.
>
>Available days = Days in year - (Saturdays + Sundays + Bank Holidays)
>
>(Available Days - Time Off) = Capacity
>
>Is MySQL aware of UK Bank Holidays or do I have to create a separate table 
>and keep it updated with Bank Holiday dates?
>
>Thanks for your help.
>
>
>Shaun 
>
>
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.15/80 - Release Date: 8/23/2005