DD-MMM-yyyy-HH:MM:SS
20-Feb-2013-17:23:34
Varchar
SELECT EmployeeName,JoinDate FROM Employees WHERE JoinDate BETWEEN '20-Jan-2013-00:00:00' AND '20-Feb-2013-23:59:59'
CAST(STUFF(JoinDate,12,1,' ') AS DATETIME)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)