title: Convert date in VARCHAR column (custom format) to DATE type in SQL Server
body: <p>In my MS SQL Server 2008 database, I have the table with VARCHAR column which stores date formatted as YYMMDD. I'd like to cast/convert it to DATE data type in SELECT query. How to do that?</p>