Date Timezone MSSQL

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