Home Forums Article Discussions Article Discussions by Author Discuss content posted by Richard Warr Fun(?) with DATETIME2 RE: Fun(?) with DATETIME2

  • September 28, 2011 at 8:12 am

    #1387793

    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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.