Previous Date with Current Date in SQL Server

Here, if you want to know the date of the previous date from the current date.

 

select cast (getdate() as date)      

select cast((getdate()-7) as date)

 

Simply, copy/paste the code and run. You will see the difference.

 

Note

(getdate()-7)  this will display the date of 7 days prior date