SQL Server data conversions from date/time values to character types

In this article, I explain how to convert DATETIME and SMALLDATETIME data types to character data and how character data can be converted to date/time data. Specifically, the article describes how Transact-SQL supports two built-in functions for converting data in SQL Server -- implicit conversion and explicit conversion.

The article continues at http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1324835,00.html