My dilema,
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.
Thanks
DATE
s as VARCHARs is a very bad idea. There is a bit of fiddling with formatting but soon becomes second nature. The main thing is that it confuses the optimizer and could slow your system. Plus, datetime functions won't work with strings.