sql query between not working
Posted on 2011-09-02
I am working with sql server 2005.
I am trying to execute a query like "SELECT username,date, convert(datetime, actionDate,3) FROM logs WHERE ID>0" and that is working fine.
when i try it with "SELECT username,date, convert(datetime, actionDate,103) FROM logs WHERE convert(datetime, actionDate,103) > '01/06/2010'" then i get an error.
i get error for the between statement also.
The records exist in the database.
Where do i missing something here?
Thanks in advance.