UTCNow

This function returns the current date and time in Universal Time Coordinated time. When multiple rows are affected, the value reflects the time at which the statement (such as SELECT or UPDATE) began to execute. There are no arguments for this function.

The syntax is: 

UTCNowD{}

Example

This example returns a timestamp with the current UTC value of the date and time. In the sample data, the UTC is 2023-12-28T17:32:45Z (December 28, 2023 at 5:38:47 PM).

UTCNowD{}

Field1 Results
1 2023-12-28T17:38:47Z
2 2023-12-28T17:38:47Z
3 2023-12-28T17:38:47Z
4 2023-12-28T17:38:47Z

Last modified: Tuesday May 21, 2024

Is this useful?