Select query problem for different date ranges

Question

hi I am getting problem in SQL select query. For ex: Select * from table where date>='12/25/2009' and date Please tell me why this select query is not working for daterange between different year.

radar radar · Answer

try set dateformat mdy & select statement

soumya shanbhag · Answer

Hi Rekha I tried but am not getting records.See once this query am getting null value. Select Min(TotalAvalablity) as TotalAvalablity from RoomAvailability where REPLACE(CONVERT(varchar(50)ReserveDate 101) ' ' '-')>='12/31/2009' and REPLACE(CONVERT(varchar(50)ReserveDate 101) ' ' '-') In this ReserveDate is datetime datatype only.

Rekha Singh · Answer

soumya  pls be a bit more specific .. the query is correct and gives output data between 2 given dates