SQL Server/T-SQL/Date Timezone/GETUTCDATE

GETUTCDATE: returns the GMT, or Greenwich Mean Time at the current date and time

   <source lang="sql">

2> SELECT GETUTCDATE() 3> GO

---

2006-10-12 14:18:37.920 (1 rows affected)

      </source>
   
  

GETUTCDATE(): use the time zone setting on the server to determine the equivalent Universal Time Coordinate time

   <source lang="sql">

1> 2> SELECT GETUTCDATE() 3> GO

---

2006-10-13 02:50:21.623 (1 rows affected) 1>

      </source>