Convert String in SQL server table to Datetime and use in Select Query

See more:

SQL-Server

I have a table in which Date time is stored in Varchar field in the fallowing format
DD-MMM-yyyy-HH:MM:SS, which is like 20-Feb-2013-17:23:34

So, now I wanted to use select query on this table for example,
let table be Employees and JoinDate is Varchar

Now my query look like below

SELECT EmployeeName,JoinDate FROM Employees WHERE JoinDate BETWEEN '20-Jan-2013-00:00:00' AND '20-Feb-2013-23:59:59'

But my query results unexpected results than what I expected.

Now my question is how to get the employees joined between '20-Jan-2013-00:00:00' AND '20-Feb-2013-23:59:59'.