Mega Code Archive

 

Categories / MSSQL Tutorial / Data Convert Functions

 

SELECT US Date

5>  SELECT 'US Date: ' + CONVERT(VarChar(50), GETDATE(), 101) 6> GO ----------------------------------------------------------- US Date: 08/07/2008 (1 rows affected)