Date Timezone MSSQL

  1. Home
  2. MSSQL
  3. Date Timezone
  4. CONVERT(VarChar(50), GETDATE(), 102)
1>
2>
3> SELECT 'ANSI Date: ' + CONVERT(VarChar(50), GETDATE(), 102)
4> GO
-------------------------------------------------------------
ANSI Date: 2006.10.12
(1 rows affected)
1>