When you update an entry for a column containing dates in a table in a MySQL or MariaDB database, you need to enclose the date in quotes. E.g.:
MariaDB [accounts]> UPDATE Invoices SET Date_Sent='2015-08-29' WHERE Name='Acme';
If you don't the contents of the date field will appear as
0000-00-00.
You also need to enclose the date in quotes when querying a database. E.g.:
MariaDB [accounts]> SELECT * FROM Invoices WHERE Date_Sent='2015-08-29';
Otherwise, you will get an empty set for the query results.
