Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gayoosoftware
Starting Member
8 Posts |
 Posted - 2008-04-21 : 11:42:58
|
| what is the minimum date can be feed in data for DateTime in SQL Server?example:I am using 01/01/1429 (arabic date), I tried in SQL Server 7.0,2000,2005 not work? what to do ? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-04-21 : 11:51:04
|
| The earliest date that you can store in a SQL Server datetime datatype is 1753-01-01 00:00:00.000.If you need to store a date like that you will need to use a different datatype.CODO ERGO SUM |
 |
|
|
gayoosoftware
Starting Member
8 Posts |
Posted - 2008-04-21 : 12:06:59
|
| thank you very much.I am wondering, because,MS Access, Oracle,My SQL etc., everything accept any date. but, SQL Server why like this limitations. if someone new to sql server he will feel its like issue in SQL Server he change to another RDBMS (specialy for arabic countries still here is 1429). |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-04-21 : 12:18:47
|
| If you have questions about why SQL Server does not have a particular feature, you should ask Microsoft. |
|
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2008-04-21 : 12:52:14
|
| Hijri Dates in SQL Server...http://www.microsoft.com/globaldev/DrIntl/columns/002/default.mspx#EADRyan Randall Solutions are easy. Understanding the problem, now, that's the hard part. |
|
|
|
|
|
|
sql server data type DateTime