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

  • May 6, 2009 at 10:14 pm

    #990120

    Atif Sheikh (5/6/2009)

    The question looks like this (at least on my PC)...

    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

    Am I about to learn learn something new here, or is it a formating issue...?

    Hey Atif, it is a formatting issue. All of the <span class=...> text is HTML markup that was not being properly rendered. I had to copy and paste into a text editor and remove the mark up just to figure out what the code was doing. Hopefully someone comes by soon to resolve the issue, or one could technically say that running the code results in an error. 😉