[dba-SQLServer] Holidays by Nation and State/Province/Canton/ etc.

artful at rogers.com artful at rogers.com
Fri Jan 12 09:49:20 CST 2007


Thanks for your reply. It appears from your reply and others that there is no modeling choice but to have a table recording the holidays of interest in the jurisdictions of interest. Then, using this table to metaphorically subtract those days from the date range of interest, we can then determine the number of business days between x and y.

Arthur

----- Original Message ----
From: "Elam, Debbie" <DElam at jenkens.com>
To: "dba-sqlserver at databaseadvisors.com" <dba-sqlserver at databaseadvisors.com>
Sent: Friday, January 12, 2007 9:24:57 AM
Subject: Re: [dba-SQLServer] Holidays by Nation and State/Province/Canton/ etc.

There are state holidays in the US as well as national ones.  For the most
part, only State employees take the state holidays off.  There are sometimes
local holidays as well.  Where I work, we have another office in the same
state that takes a holiday for a local festival.  To be fair, they probably
could not get into the building that day anyhow.  They have a street
festival happening practically in their laps.

Debbie

-----Original Message-----
From: artful at rogers.com [mailto:artful at rogers.com] 
Sent: Thursday, January 11, 2007 9:14 PM
To: dba-SQLServer
Subject: [dba-SQLServer] Holidays by Nation and State/Province/Canton/etc.


I write this from Canada, wherein the days designated Holidays vary from
province to province. Some Holidays are designated National and apply to all
provinces. Other Holidays are local to the particular province of interest.

Does the same thing apply to the USA? Are there, for example, holidays in
Georgia that are not recognized in New York? Is there some definitive list
of these that can be downloaded from someplace?

Second, one assumes that this also applies to other nations. Let us take
Switzerland as a hypothetical example. Are there holidays in Canton X that
are not holidays in Canton Y? 

Gustav, what say you about Denmark? (I confess that I don't even know what a
region of Denmark is called -- a province? a state? an enclave?) 

I think we have a few Dutch listers here too. What say you? 

Any French? Belgians? Italians? Spanish? Portuguese? Bulgarians? Serbians?
etc.

One assumes, based solely on the difference between Canada and the USA, that
there are different national holidays and also "provincial" holidays.

Can anyone supply more detail into this?

TIA,
Arthur


TIA,
Arthur

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com
- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject
to the Attorney-Client Privilege, (2) an attorney work product, or (3)
strictly confidential. If you are not the intended recipient of this
message, you may not disclose, print, copy or disseminate this information.
If you have received this in error, please reply and notify the sender
(only) and delete the message. Unauthorized interception of this e-mail is a
violation of federal criminal law. 
This communication does not reflect an intention by the sender or the
sender's client or principal to conduct a transaction or make any agreement
by electronic means.  Nothing contained in this message or in any attachment
shall satisfy the requirements for a writing, and nothing contained herein
shall constitute a contract or electronic signature under the Electronic
Signatures in Global and National Commerce Act, any version of the Uniform
Electronic Transactions Act or any other statute governing electronic
transactions.
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com








More information about the dba-SQLServer mailing list