DateTime format can cause a problem when deleting or searching and only wanting to use the day in question not the time as well.
Use this code to get round that problem…use the wildcard!
|
1 2 3 |
DELETE FROM reports WHERE mydate > "2014-05-30 *" |
