Results 1 to 4 of 4

Thread: Using Date

  1. #1
    Join Date
    Jan 2005

    Unanswered: Using Date earler to 1763

    Is it possible to use date earler to 1763 in MSSQL server. It means like 10/10/1500. Because I use SQL Server 2000 with Power Builder. There I face this date problem (bug!).

    Is there any solution
    Last edited by Anbazhaganac; 02-21-05 at 08:36.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I'm just curious, but why on earth would you want to do this?

    The biggest problem that you run into is that before the mid 1700's, you had to get into the where as well as the when for a date to have meaning... The Julian to Gregorian shift was not observed at the same time everywhere. See one of the shift explanations for more details.

    In other words, May 1, 1540 was observed over an almost two week period throughout Europe. Without knowing where it was May 1, you don't really know when it was May 1!

    By the end of 1763, most of Europe worked from one calendar. The Europeans chronicled nearly everything in the world, or at least offered an easy way to convert from other calendars to theirs. That was the first time in recorded history that a single calendar could be effectively used world-wide.

    The short answer is that to store dates before what SQL Server supports, you really need to use a VARCHAR variable large enough to describe the date, since you need to store both location and that location's observed date. This gets really messy, and lots of tools (like Powerbuilder) just ignore the difference, figuring that any dates before about 1805 are probably estimates anyway.


  3. #3
    Join Date
    Apr 2002
    Toronto, Canada
    you cannot do it easily

    see | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Jan 2005
    Thanks a lot.
    Actually already I read a article abt Unix date and calender display. From ur explanation I understood the real story begind my problem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts