Why do Taobao Jingdong and other manufacturers use this format for timestamps yyyy-MM-ddHH:mm:ss?
This is mainly reflected in the fact that the time stamp transmitted by the request interface requires this format and does not know what database to use.
Timestamp field type (MySQL) selection:
Select 1 (recommended):
Unsigned int(10) 4294967295 (4 bytes 32-bit unsigned 2 32-1)
echo date(‘Y-m-d H:i:s’, 4294967295);
It can be seen that the int(10) field cannot store the timestamp after this time.
At this time, 8 bytes of bigint(20) can be used to ensure that the timestamp of Earth 2050: The Future of Energy’s lifetime can be stored:
Unsigned Bigint (20) 18446744073709551615 (8 bytes 64-bit unsigned 2 64-1)
echo date(‘Y-m-d H:i:s’, 18446744073709551615);
Note that 32-bit MySQL can use 8-byte bigint type to store 64-bit integers.
Timestamp: Time stamp, ranging from 1970-01-01 00:00:01 UTC to 2038-01-09 03:14:07 UTC, stored as the number of seconds since the era (1970-01-01 00:00:00 UTC).
echo strtotime(‘2038-01-19 11:14:07’); Returns 2147483647
Datetime: date and time, supported from 1000-01-01 00:00:00 to 9999-12-31 23:59:59
WordPress saves the timestamp of an article in datetime.