Click here to Skip to main content
Click here to Skip to main content

Century Date Tables

, 26 Oct 2000
Rate this:
Please Sign up or sign in to vote.
SQL DDLs for creating table structures and inserting the data for a 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
<!-- Download Links -->
  • Download source files - 2 Kb
  • <!-- Main HTML starts here -->

    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.

    License

    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

    Share

    About the Author

    John Bevilaqua

    United States United States
    No Biography provided

    Comments and Discussions

     
    GeneralMillennium Length PinsussS. Hare27-Oct-00 5:02 
    GeneralRe: Millennium Length PinsussEric30-Oct-00 5:40 
    GeneralRe: Millennium Length PinsussJames Curran30-Oct-00 6:29 
    GeneralRe: Millennium Length PinsussEric30-Oct-00 6:42 
    GeneralRe: Millennium Length PinsussCrispy30-Oct-00 12:44 
    GeneralRe: Millennium Length PinsussKastellanos Nikos3-Nov-00 5:08 

    General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

    Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

    | Advertise | Privacy | Mobile
    Web03 | 2.8.141022.2 | Last Updated 27 Oct 2000
    Article Copyright 2000 by John Bevilaqua
    Everything else Copyright © CodeProject, 1999-2014
    Terms of Service
    Layout: fixed | fluid