Delete query with respect to date only

[habib009pk]

Hi Friend

 

I am facing a problem i have different records with same date but with different times. The feilds having datatype datetime. Now i want to delete all the records with same date only..

but when i am running this query:

 

DELETE FROM auct_lots_full WHERE lot_date='2009-07-31';

 

so this query doesn't gave me any positve result..

 

Please Help me regarding this query

 

Thanks And Regards

 

[kickstart]

Hi

 

The simple solution would be to do:-

 

DELETE FROM auct_lots_full WHERE lot_date BETWEEN '2009-07-31 00:00:00' AND '2009-07-31 23:59:59';

 

All the best

 

Keith

[gevans]

Or you could just pull the date from datetime

 

DELETE FROM `auct_lots_full` WHERE DATE(`lot_date`) = '2009-07-31';