SQL SERVER GET UTC DATE GETUTCDATE COORDINATED UNIVERSAL TIME DATE AND TIME

SQL SERVER GET UTC DATE GETUTCDATE COORDINATED UNIVERSAL TIME DATE AND TIME

-- EXAMPLE FOR TODAY'S DAY

SELECT GETUTCDATE();

-- EXAMPLE FOR YESTERDAY'S DATE

SELECT GETUTCDATE()-1;

--EXAMPLE OF ONE WEEK (7 DAYS) AGO DATE

SELECT GETUTCDATE()-7;