Date Timezone MSSQL

  1. Home
  2. MSSQL
  3. Date Timezone
  4. CONVERT(varchar, getdate(), 1(2,3,4,5,6))
1> SELECT
2>    CONVERT(varchar, getdate(), 1),
3>    CONVERT(varchar, getdate(), 2),
4>    CONVERT(varchar, getdate(), 3),
5>    CONVERT(varchar, getdate(), 4),
6>    CONVERT(varchar, getdate(), 5),
7>    CONVERT(varchar, getdate(), 6)
8> GO
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ -------------------------
-----
10/12/06                       06.10.12                       12/10/06                       12.10.06                       12-10-06                       12 Oct 06
(1 rows affected)
1>