Does MySQL still converts `0::timestamp` into the date '0000-00-00'? I have neve... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		marcosdumay on Dec 6, 2021 \| parent \| context \| favorite \| on: Leaving MySQL 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 on Dec 6, 2021 [–]

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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact