MySQL year 2038 Pr‌o‌b‌l‌e‌m -


i trying install mysql on linux machine fails install , throws following error

'this mysql server doesn't support dates later 2038'

what can possibly solve problem or should wait oracle patch problem?

nasty. depends on column used for.

you store date/times in iso standard string format yyyy-mm-ddthh:mm:ss.ssssssssz, convert comparison purposes in code using 64 bit long long.

hopefully year 9999 enough? :-)

storing datestamps canonical strings supports comparison, indexing, have own validation.


Comments

Popular posts from this blog

java - Jasper subreport showing only one entry from the JSON data source when embedded in the Title band -

serialization - Convert Any type in scala to Array[Byte] and back -

SonarQube Plugin for Jenkins does not find SonarQube Scanner executable -