Home Forums Article Discussions Article Discussions by Author Discuss content posted by bitbucket SQL_VARIANT 1 RE: SQL_VARIANT 1

  • November 10, 2011 at 5:41 am

    #1405664

    Hugo Kornelis (11/10/2011)

    Nice question, Ron!

    I only got it right because I figured that the relative order of the date and time related values would be "logical". And since the conversion to smalldatetime would chop off the seconds and the conversion to date the entire time portion, the only logical ordering of those three would be date / smalldatetim / datetime.

    I used the same process, but was idiot enough to stop when I figured out the hierarchy of the data types (including the inferred position of date). Would have been beneficial to actual DO the process of type conversion! Well, at least NOW my mind is working this morning! 😉

    Thanks for the question.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn