Mega Code Archive

 

Categories / MSSQL Tutorial / Data Convert Functions

 

SELECT ANSI Date

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