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

Tuesday Aug 12th 2008 by DatabaseJournal.com Staff

Learn two built-in functions for SQL Server data conversion from T-SQL date/time values to character types. These methods include SQL Server CAST and CONVERT.

[From Search SQL Server]

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

Mobile Site | Full Site