MySQL year 2038 Problem -
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
Post a Comment