DateTime issue with "high value" datetimes and reader
Posted by: James Duerr
Date: March 02, 2005 04:39PM

Interesting thing,

I had created a database, which had a few datetimes on it, after a bit of messing around I managed to get storage and work out null values (for myself, I use 0001-01-01 as null for all my datetimes as that works fine for what I'm doing).

But I was using 9999-12-31-23.59.59 as high values, and found that, well the reader aborted with an exception, I had to lower the year down to 9996 to get it to work?

Anyone ever come across anything like this before?

The exception seems to be

System.Argument.OutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: Year, Month, and Day parameters describe an unrepresentable DateTime.

The command I'm using to set the date is

System.DateTime HighDate = new System.DateTime(9999.12,31,23,59,59);

If I change 9999 down to 9996 it works fine, but 9999 doesn't seem to work (this is for reading, I can do a create fine but create is just using strings so that's easy.

Options: ReplyQuote


Subject
Written By
Posted
DateTime issue with "high value" datetimes and reader
March 02, 2005 04:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.