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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to