Date datatype

I need to store older dates than Jan 1 1753. What date type should I use? I
need to store for example 26 August 1537.
With thanksHi
Probably you will need to store it as VARCHAR(n) column.
"EdwardH" <EdwardH@.discussions.microsoft.com> wrote in message
news:55BDB48D-B01A-4075-815D-C139E45E9CF8@.microsoft.com...
> I need to store older dates than Jan 1 1753. What date type should I use?
I
> need to store for example 26 August 1537.
> With thanks|||Hi Edward,
You can go with Varchar data type.
Thanks
Hari
SQL Server MVP
"EdwardH" <EdwardH@.discussions.microsoft.com> wrote in message
news:55BDB48D-B01A-4075-815D-C139E45E9CF8@.microsoft.com...
>I need to store older dates than Jan 1 1753. What date type should I use? I
> need to store for example 26 August 1537.
> With thanks|||That means that the column would have not "date" abilities.
"Uri Dimant" wrote:
> Hi
> Probably you will need to store it as VARCHAR(n) column.
> "EdwardH" <EdwardH@.discussions.microsoft.com> wrote in message
> news:55BDB48D-B01A-4075-815D-C139E45E9CF8@.microsoft.com...
> > I need to store older dates than Jan 1 1753. What date type should I use?
> I
> > need to store for example 26 August 1537.
> > With thanks
>
>|||What "date abilities" do you want? For ancient dates it's hard to do
any of the things we take for granted with DATETIME (validation,
comparison, sorting, date arithmetic). I expect you know that our
Gregorian Calendar didn't exist in 1537 so what calendar logic would
you expect to apply to such a date? You have to design them yourself
I'm afraid because SQL Server has no way of knowing what calendar was
in use in your particular part of the world on any given date.
--
David Portas
SQL Server MVP
--|||Hi
Look at :
http://codebetter.com/blogs/raymond.lewallen/archive/2004/12/01/34519.aspx
http://groups.google.ch/group/microsoft.public.sqlserver.server/browse_thread/thread/9b6613e416ae827c/55b87fa92fdeea5a?q=sql+date+1753&rnum=2&hl=en#55b87fa92fdeea5a
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"EdwardH" wrote:
> I need to store older dates than Jan 1 1753. What date type should I use? I
> need to store for example 26 August 1537.
> With thanks