i would like to run select sql command with where condition which is from type of datetime and the condition "where" will be date and not datetime
issuedate is look like: 2007-03-22 00:00:00.000
what i have to change in the below sql command that it will run?
select * from cutheader where issuedate between '2007-0-22' and '2008-02-27'
Server: Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.