FROM_SECOND

from_second

description

syntax

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.

example

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                                 |
+--------------------------------------+

keywords

FROM_SECOND,FROM,SECOND,MILLISECOND,MICROSECOND