finding date in data

[Selen]

Hi,
I am using
select date from table where Convert(char(10),Date,104)>='17.03.2004'

but only comes date which is bigger than 17 ..the other not.

FOr example I cant see 10.04.2004 ..

What is wrong???

Thanks

 

[José Joye]

This is because you are comparing ascii values. If you want to go this way,
you should test yyyy.mm.dd.
In this way, you would have a correct behavior with the ">" and "<" signs
Use 102 instead of 104 for the style and test '2004.03.17'

José

 

[Branimir Giurov]

I want to add something to this -
It will be faster executed if you parse the date in a local variable and
then make the select statement.

Otherwise, you're converting too many times the same value.


Cheers,
Branimir