Problem with select dates

[70001864]

hi I have a strange problem

If I want to select a date, I can do it with this select statement with succes

SELECT * FROM tbltable
WHERE (CONVERT(varchar(10), InitDate, 105) LIKE @InitDate)

BUTTT !

If I want to have a select statement >= I get all data from the database also the date before the >= date, so what am I doing wrong ??

SELECT * FROM tbltable
WHERE (CONVERT(varchar(10), InitDate, 105) >= @InitDate)

 

[djj55]

Do not use the varchar conversion because you will be comparing character strings not dates.

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[markros]

Take a read here
The ultimate guide to the datetime datatypes
Bad habits to kick : mis-handling

date / range queries

PluralSight Learning Library