Home Forums Article Discussions Article Discussions by Author Discuss content posted by Anders Hellner Weird datetime conversions RE: Weird datetime conversions

  • May 7, 2009 at 12:54 am

    #990155

    RBarryYoung (5/6/2009)

    I couldn't really read this question, It was all just IFCodes.

    The code was properly formatted in the daily mail, but not on the site. For those who have lost their mail, or who don't subscribe to it, here is the code as I found it in my mail:

    SELECT CONVERT(datetime,-1)

    UNION

    SELECT CONVERT(datetime,0)+CONVERT(datetime,-1)

    UNION

    SELECT CONVERT(datetime,-1)-CONVERT(datetime,0)

    UNION

    SELECT CONVERT(datetime,0)-CONVERT(datetime,1)

    UNION

    SELECT CONVERT(datetime,0)-1

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/