DateTime format – search or delete – Wildcard

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!
DELETE FROM reports WHERE mydate > "2014-05-30 *"