Century Date Tables

Introduction

Here is a copy of the SQL DDLs for creating table structures and inserting the data for a SQL Server set of tables suitable for producing pick lists for validation of the Month Names, Month Numbers, Days in each Month and Years in the 20th Century, for example. I hope to post ASP Source later which accesses these tables to produce linked pick lists to assure that cross field valids are handled correctly. Leap year logic and Century crossover will be handled in the code produced later. This is my first attempt at producing some modestly valuable data and code to contribute to generally available freeware as a payback for some of the nice code I received previously

By the way I am one of those who insists that the 21st Century does not officially begin until next year and these tables have assigned the Year 2000 to the 20th Century. You can change this value if you believe otherwise, but the First Century A.D. begin with the Year 1 A.D. and ended with the Year 100 A.D. There was never a Year Zero, so why insist otherwise and why change methodologies now? Trivia question: Which Millennium was actually longer in duration, the First or the Second or were they of the same duration, and if so, why? The answer may surprise some, but you can win a few mugs of grog over this one at your local pub if you wish. First one to answer correctly wins free source code for Birth Date validation.

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here