DATETIME FROM_SECOND(BIGINT unix_timestamp) DATETIME FROM_MILLISECOND(BIGINT unix_timestamp) DATETIME FROM_MICROSECOND(BIGINT unix_timestamp)
Converts a timestamp to its DATETIME represent, with argument as an integer and returned as a DATETIME type. Returns NULL if unix_timestamp < 0 or if the function result is greater than 9999-12-31 23:59:59.999999.
mysql> set time_zone='Asia/Shanghai'; mysql> select from_second(-1); +---------------------------+ | from_second(-1) | +---------------------------+ | NULL | +---------------------------+ mysql> select from_millisecond(12345678); +----------------------------+ | from_millisecond(12345678) | +----------------------------+ | 1970-01-01 11:25:45.678 | +----------------------------+ mysql> select from_microsecond(253402271999999999); +--------------------------------------+ | from_microsecond(253402271999999999) | +--------------------------------------+ | 9999-12-31 23:59:59.999999 | +--------------------------------------+ mysql> select from_microsecond(253402272000000000); +--------------------------------------+ | from_microsecond(253402272000000000) | +--------------------------------------+ | NULL | +--------------------------------------+
FROM_SECOND,FROM,SECOND,MILLISECOND,MICROSECOND