In MySQL Docs, the range of TIMESTAMP is from '1970-01-01 00:00:01.000000' UTC to '2038-01-19 03:14:07.499999' UTC.
But this SQL statement can be execute and display correctly:
SELECT TIMESTAMP('1970-01-01 00:00:00.000000', 0.00001) FROM DUAL;
The result is '1970-01-01 00:00:00.000010'. Out of the range?
I know that timestamp is the differ that is between current time and '1970-01-01 00:00:00.000000'.
Is the unit of differ second or millsecond? And is the implement of TIMESTAMP based the BIGINT (or long)?
MySQL Docs: enter image description here
And the result of SQL statement: enter image description here