Don't forget this date.

Question

Don't forget this date.

Viewing 4 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply

Oleg Netchaev SSCertifiable Points: 5276 More actions · Answer 1

paul.goldstraw (4/8/2010)
Any idea what the latest date is? I got as far as 500,000 days into the future before i gave up, I doubt i'd have much use for this unless i'm using DBCC timewarp though

In numbers it is 2958463. You can view it by running

select cast(cast('9999-12-31' as datetime) as int)

Oleg

TomThomson SSC Guru Points: 104773 More actions · Answer 2

Good question. And there hasn't been a single serious complain about it (at least I think VVK was joking).

I couldn't remember it, couldn't be bothered to look it up, so wrote a program to compute it (try catch dropping 10s of years from 0, dropping years from the limit of that, and then trying to drop 3ms from the limit of that just in case). Of course I could have just gone by days but I couldn't shake the bad habit of a lifetime (rating CPU efficiency as more important than my own).

Tom