SQL query

[Nadir]

Hi all,

Have you an idea to purge table with sql query?
I want to delete the last 6 months records with sql query like this

DELETE FROM table
WHERE DateTime < 'current datetime - 6 mounths'

Thanks for help

[KS-Soft Europe]

I want to delete the last 6 months records with sql query like this

DELETE FROM table
WHERE DateTime < 'current datetime - 6 mounths'

Do you mean to leave only the last 6 months, don't you? I suppose you want to leave last 6 months data and delete older records, right?

As I remember, you have used MS SQL? Correct? Then you should use Transact SQL Syntax. E.g.

DELETE FROM table
WHERE DateDiff(mm,DateTime,GetDate()) > 6

http://msdn.microsoft.com/library/defau ... b_5vxi.asp

But before exucuting such query, I recommend you to replace "Delete" sentence with "Select * " to ensure the correct data would be deleted

Regards,
Max

[Nadir]

I suppose you want to leave last 6 months data and delete older records, right?

Yes you have right
Thanks Max