I was requested to populate a table of sample data and I completed the command to add a date.
I entered '07-07-2016' as sample data. When running a query the "date_ordered" field came back as "0000-00-00".
I need to convert the already stored data to the MM-DD-YYYY format. I would prefer to convert the data completely, not just the view.