Update date field in MySql
Posted on 2014-01-19
What a huge @#$%^ mistake.
I took on converting a @#$%^ asp site to php.
Is there any @#$%^ way to update a date field?
PHP or MySQL just wants to update to 0000-00-00 00:00:00
What if 0000-00-00 00:00:00 doesn't work for you? Let's say someone wasn't born on 0000-00-00 00:00:00 or they didn't start employment on 0000-00-00 00:00:00? Can @#$%^! MySQL or PHP handle any date other than 0000-00-00 00:00:00?
Even more of a huge leap... can the field not contain a time?
Is there a way in which could look at the field and just see 1/19/2014?