Delete query with respect to date only
Posted: Sat Aug 01, 2009 2:05 am
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
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