problem with selecting data between two dates in sqlserver
posted 10 years ago
Hi, i want to execute a date between select query using preparedStatement in sqlserver 2000. my date is in string format,and before setting in preparedstatement i am converting it by Date.valueOf(string) as Date in DataBase is in smallDateTime Format. but it is not working and i am also not getting any other way to select data from table between two dates. please help me out. thanks in advance.