Forums - C# Corner

Forum guidelines
Ramon Quintana

Ramon Quintana

  • 1.7k
  • 87
  • 1.2k

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)