Originally posted by Oleg Zernov
In situations like this you should use
'convert' function in WHERE clause
(See the description in SQL BOL).
If you write
convert(datetime, '22-09-2002', 105)
instead of
'22-09-2002'
you'll get the expected result, so you
may not be aware about the current date format settings.

Thanks Oleg.