date Form Datetime using Where Clause

[Sachin Karande]

select * from tbl_Task where Convert(datetim e,Time,101)='20 11/12/28'


2011/12/28 data is avalable in tbl_Task Table but i retrive data fro only date in datetime datatype


Plz sove this query

[Sivaranjani]

U want to retrieve data using date only ya? Please ask Clearly.

[ck9663]

Here, read this...

Happy Coding!!!


~~ CK