Query to delete datesDear all,
In database more than 5 years events are stored.we need to delete 2012 to 2014 events only from the database.Kindly give me some idea to perform this.
Thanks in advance
DELETE FROM TABLENAME
WHERE DATEFIELD BETWEEN FROMDATE AND TODATE
Delete from EventTable
Where EventDate >= '01/01/2012'
And EventDate <= '31/12/2014'