Aritmetic Overflor On READING A Date Value

I have a date in my SQL Server Database of 3/12/2204. This is, of course, 200 years after today and is not a correct value.





However, when my repeater is trying to display the records in that table, I get the following error:





"Arithmetic overflow error converting expression to data type datetime."





Here is the stack trace:





[SqlException: Arithmetic overflow error converting expression to data type datetime.]


System.Data.SqlClient.SqlDataReader.Read() +157


System.Data.Common.DbEnumerator.MoveNext() +44


System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +504


System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +48


System.Web.UI.WebControls.Repeater.DataBind() +23








Now, none if this is in my own code, and so it is difficult to put any decent error-trapping. This is all in the built-in ASP.NET Repeater and SqlDataReader classes.





Why on Earth would there be an arithmetic overflow here? Note that the original table this is coming from has the date stored in the SqlDbType.DateTime format! In other words, why is there any conversion needed?





Perhaps it is converting the data from SqlDbType to DbType, but even then, what is so difficult about dealing with the year 2204? According to BOL, the DateTime data type should support up to the year 9999!





Note that when I access the table through Enterprise Manager and change the date, the error disappears. I tried a number of over-and-under tests, and I get this error on any date after 3/19/2151!





Does ASP.NET not support dates after that? I doubt it, but does anyone have an explanation for this?





Thanks,


JK