Data Convert Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Data Convert Functions
  4. SELECT US Date
5>  SELECT 'US Date: ' + CONVERT(VarChar(50), GETDATE(), 101)
6> GO
-----------------------------------------------------------
US Date: 08/07/2008
(1 rows affected)