Although I have answered a few, I think it's the first time I have ever posed a question on this forum.
SQL Anywhere documentation has stated for years that "the useful range of TIMESTAMP date types is from 1600-02-28 23:59:59 to 7911-01-01 00:00:00".
The truth seems to be "the useful range of TIMESTAMP date types is [0001-01-01 00:00:00, 7911-01-01 00:00:00)" using set notation, or "the useful range of TIMESTAMP date types is from 0001-01-01 00:00:00 up to, but not including, 7911-01-01 00:00:00". This statement allows for fractional seconds following 7910-12-31 23:59:59.
OK, so my question is, where did this 1600-02-28 23:59:59 come from? Dusting off a Watcom SQL 4.0 tome, I read that it may have been true in Watcom SQL 3.0. But after that, I don't believe it ever was true. But I can't believe that someone just invented this special date.
Or is it true, and there is some situation of which I am not aware where dates earlier than this return incorrect results?
asked 29 Sep '16, 14:57