Ramon Quintana

Ramon Quintana

  • NA
  • 404
  • 61.7k

I want to delete all less two days before actual date

Oct 24 2018 10:25 AM
hi, i need to left only records in my table with two days before actual date:
 
I try this:
 
delete from dbo.prueba where DATE = (select GETDATE()) -2
 
but NOTHING HAPPENED 
 
Please help me  

Answers (14)