3 ms·
Does MySQL still converts `0::timestamp` into the date '0000-00-00'? I have never seen a MySQL database that didn't have problems with dates. (But I haven't lo
by marcosdumay 5y ago
Does MySQL still converts `0::timestamp` into the date '0000-00-00'?
I have never seen a MySQL database that didn't have problems with dates. (But I haven't looked in a while.)
- normalocity 5y agoIt can function like this, yes. There's a flag for the `sql_mode` that enables/disables this functionality, and I believe zero dates are disallowed by default in MySQL 8.0+ IIRC.