Don't forget this date.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Carla Wilson-484785... » Don't forget this date.

34 posts, Page 4 of 4

«««1 2 3 4

Don't forget this date.

Rate Topic

Display Mode

Topic Options

Author

Message

Oleg Netchaev

Posted Thursday, April 08, 2010 8:41 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:53 AM
Points: 1,662, Visits: 1,709

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

Post #899637

L' Eomot Inversé

Posted Thursday, April 08, 2010 11:48 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:27 AM
Points: 7,093, Visits: 7,149

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
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #899849