delete all records except the last 2 days using sql

it is not deleting anything.  All the data are still there.  Here is how the data look like

2015-03-06 20:30:00.000
2015-03-06 21:00:00.000
2015-03-06 21:30:00.000
2015-03-06 22:00:00.000
2015-03-06 22:30:00.000
2015-03-06 23:00:00.000
2015-03-06 23:30:00.000
2015-03-05 00:00:00.000
2015-03-05 00:30:00.000
2015-03-05 01:00:00.000
2015-03-05 01:30:00.000
2015-03-05 02:00:00.000
2015-03-05 02:30:00.000

Select allOpen in new window

If the table is not too large, you can delete them directly:


DELETE FROM table_name
WHERE datetime_column < DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) - 2, 0)

Those dates are from the last 2 days which you said you wanted to retain. "Everything...except the last 2 days"

thanks

Was there something wrong with my proposal?

UnifiedIS,
No nothing was wrong your proposal and i meant to give you all the points.  I thought you were the only one who answered my questions and i did not look at the names.  Sorry but how can i correct my mistake now?

I think EE has to reopen it once it's been solved but I don't see the link for it.  It's not that big of a deal, I'll survive without the points. I'm glad we were able to help you.

thanks