SQL Server/T-SQL/Date Timezone/GETUTCDATE

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

2> SELECT GETUTCDATE()
3> GO
-----------------------
2006-10-12 14:18:37.920
(1 rows affected)

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

1>
2> SELECT GETUTCDATE()
3> GO
-----------------------
2006-10-13 02:50:21.623
(1 rows affected)
1>