SyntaxFix
Write A Post
Hire A Developer
Questions
Try this:
select * from xxx where dates between convert(datetime,'10/10/2012',103) and convert(dattime,'10/12/2012',103)