Published on: 06 Aug, 2020

How to get UTC date in TSQL?

Tumblr Digg Google Plus

What is UTC date?

UTC is the world's time standard. It is known as a coordinated universal time used as a basis for civil time today.

To get the UTC date in TSQL. There is a built-in function called GETUTCDATE. If you try to run the following SQL query.

SELECT GETUTCDATE();

If you want to remove the time, you can use the following conversion function.

SELECT CONVERT(DATE, GETUTCDATE(), 101)

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.