Refer [new] is a 64 - bit Linux system, why the system time for 2038 years the mysql will not be abl-CodePudding

[ERROR] This MySQL server doesn 't support dates later then 2038

Please everybody action

CodePudding user response:

How much is the mysql version

CodePudding user response:

reference 1st floor lzd_83 response:

how much is the mysql version

Server version: 5.1.73 Source distribution

CodePudding user response:

Should be the timestamp type you use, the scope of this type by 2038, with a datetime line
The TIMESTAMP data type is 2 for values that contain both The date and time with parts. The TIMESTAMP from a range of '1970-01-01 00:00:01 UTC to 03:14:07 2038-01-19 UTC.

CodePudding user response:

reference crynono reply: 3/f

should be the timestamp type you use, the scope of this type by 2038, with a datetime line
The TIMESTAMP data type is 2 for values that contain both The date and time with parts. The TIMESTAMP from a range of '1970-01-01 00:00:01 UTC to' The 2038-01-19 03:14:07 UTC.

Where is modified into a datetime type database changes or modifications ah, thank you