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)