getutcdate

Returns a date and time where the value is in Universal Coordinated Time (UTC). getutcdate is calculated each time a row is inserted or selected.

Syntax

getutcdate()

Examples

Example 1 – Returns a date and time in Universal Coordinated Time:
```
insert t1 (c1, c2, c3) select c1, getutcdate(), 
getdate() from t2)
```

Permissions

Any user can execute getutcdate.

Parent topic: Transact-SQL Functions

Related reference

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com