Datetime problem in Sql Server 2005
How are you?

I am facing a problem in datetime field in Sql Server 2005.

SELECT FROM SOFTSKILL WHERE
INSERT_DATE >= '2011-09-22' AND CH_INSERT_DATE <= '2011-09-23'

This is the query to extract values. But if i give same date, no records are fetching. Could you please advice me how to do this happen.

Thanks in advance.
Datetime problem in Sql Server 2005
===

How are you?

I am facing a problem in datetime field in Sql Server 2005.

SELECT FROM SOFTSKILL WHERE
INSERT_DATE >= '2011-09-22' AND CH_INSERT_DATE <= '2011-09-23'

This is the query to extract values. But if i give same date, no records are fetching. Could you please advice me how to do this happen.

Thanks in advance.