views:

113

answers:

2

I've used GetDate() in defaults for a long time.
What is the equivalent call, or logic in SQL 2005 for me to put in a default that will give me the current UTC time.

+4  A: 
GETUTCDATE()
Cade Roux
+3  A: 

GETUTCDATE()

The difference between GETDATE() and GETUTCDATE() is time zone number of the SQL Server machine.

cgreeno