SQL SERVER GET DATE GETDATE TODAY'S DATE AND TIME

SQL SERVER GET DATE GETDATE TODAY'S DATE AND TIME

-- EXAMPLE FOR TODAY'S DAY

SELECT GETDATE();

-- EXAMPLE FOR YESTERDAY'S DATE

SELECT GETDATE()-1;

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

SELECT GETDATE()-7;