I am using MS-SQL 2000. My column Date_time where it stamps date and time, 10/20/2008 12:49:47 PM.
I have a calendar where user can select a date. Sample 10/20/2008. My select statement I have this : select *from mytable where date_time between convert(datetime, '10/20/2008') and convert(datetime, '10/22/2008' ) < this does not work. I need help.