Data Convert Functions MSSQL Tutorial

3>
4> SELECT 'ANSI Date: ' + CONVERT(VarChar(50), GETDATE(), 102)
5> GO
-------------------------------------------------------------
ANSI Date: 2008.08.07
(1 rows affected)