Hacker News Reader

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.)

It 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.

Reply on news.ycombinator.com