|SYSDATETIMEOFFSET()||2013-02-26 21:09:17.4680514 +01:00||DATETIMEOFFSET|
UTC means Coordinated Universal Time and is widely used as time standard in web applications. The result above were taken on a PC with the time zone (UTC+01:00). Note that the UTC functions return the time one hour before the rest.
CURRENT_TIMESTAMP is the recommended one as it is the ANSI equivalent of GETDATE()
Don't forget that if you only need the current DATE or TIME, you can cast the return of the above functions to a DATE or TIME
SELECT CAST(GETDATE() as DATE)
which will return
For all DateTime functions visit the following link