Date Timezone MSSQL

  1. Home
  2. MSSQL
  3. Date Timezone
  4. CONVERT(VarChar(50), GETDATE(), 103)
1> SELECT 'UK/French Date: ' + CONVERT(VarChar(50), GETDATE(), 103)
2>
------------------------------------------------------------------
UK/French Date: 12/10/2006
(1 rows affected)