"Go" a Question of SQL SERVER datetime

After you have learned the previous SQL SERVER datetime precision article. Let's do another question.

IF (' 2011-07-31 00:00:00.000 ' between ' 2011-07-01 ' and ' 2011-07-31 ')
PRINT ' Yes '
ELSE
PRINT ' No '

The result is what, if you think is yes, then you are fooled, haha. Because this is not a two date type in comparison, this is the two string in the comparison.

So the result is no, of course.

If you want to compare dates, type conversions should be performed, as follows:

IF (CAST (' 2011-07-31 00:00:00.000 ' as DATETIME)
Between CAST (' 2011-07-01 ' as DATETIME)
and CAST (' 2011-07-31 ' as DATETIME))
PRINT ' Yes '
ELSE
PRINT ' No '

The result is yes.

This is also on the internet to see, feel interesting, put it over. Just for everyone to learn. Oh.

"Go" a Question of SQL SERVER datetime