Syntax
SYSUTCDATETIME ( )Return Type
datetime2(7) – The current UTC date and time, with accuracy of 100 ns.
Remarks
SYSUTCDATETIME returns the current Coordinated Universal Time (UTC) as a datetime2 value. It is not affected by the server's time zone settings or daylight‑saving adjustments.
- Use
GETUTCDATE()fordatetimeprecision (3 ms). - For local server time, use
SYSDATETIME(). - When precision is crucial, store the value in a
datetime2(7)column.
Examples
SELECT SYSUTCDATETIME() AS CurrentUTCDateTime;
-- Result: 2025-09-15 13:45:27.1234567