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 «««56789

Fun(?) with DATETIME2 Expand / Collapse
Author
Message
Posted Wednesday, September 28, 2011 8:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:23 PM
Points: 6,286, Visits: 7,218
hardikssit1 (9/28/2011)
I am disagree with the correct answer of this query..
I got the following result after running the same in Msg window...

1752-09-09 00:00:00.0000000

I use "Microsoft SQL server 2008 R2", Please Explain....


The explanation is in the answer to the question. This wasn't meant to be an uber-serious QOTD. It was meant as a fun little brain teaser. In certain calendars, the date doesn't technically exist. Which makes it even more interesting that MS says that it does.


Brandie Tarvin, MCITP Database Administrator

LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1182497
Posted Monday, February 27, 2012 8:44 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, May 12, 2015 10:14 AM
Points: 490, Visits: 253
Great question on the DATETIME2 that supports larger precision times and date ranges.

Thanks.
Post #1258305
« Prev Topic | Next Topic »

Add to briefcase «««56789

Permissions Expand / Collapse