Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Don't forget this date. Expand / Collapse
Author
Message
Posted Thursday, April 8, 2010 8:41 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 22, 2014 9:13 AM
Points: 1,676, Visits: 1,761
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
Posted Thursday, April 8, 2010 11:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 7:18 PM
Points: 7,930, Visits: 9,654
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
Post #899849
Posted Wednesday, March 30, 2011 12:53 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 4:40 PM
Points: 654, Visits: 375
Good question for general knowledge, thanks.
Post #1086008
Posted Tuesday, March 6, 2012 3:57 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, November 29, 2014 2:17 AM
Points: 483, Visits: 245
Good question on the Dates.
Post #1262599
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse