Previous Date with Current Date in SQL Server

This blog defines the previous date with the 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