[Koha-bugs] [Bug 27253] borrowers.updated_on cannot be null on fresh install, but can be null with upgrade

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27253

--- Comment #20 from Julian Maurice <julian.maurice at biblibre.com> ---
(In reply to Marcel de Rooy from comment #17)
> So I would propose to switch to UNIXTIME(1).
> Note that I would consider this a bug in SQL.

It's weird that '1970-01-01 00:00:00' is not a valid timestamp but it's not
really a bug IMO. MySQL documentation says that:

The TIMESTAMP data type is used for values that contain both date and time
parts. TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19
03:14:07' UTC.

https://dev.mysql.com/doc/refman/8.0/en/datetime.html

-- 
You are receiving this mail because:
You are watching all bug changes.