from_second

description

Syntax

DATETIME FROM_SECOND(BIGINT unix_timestamp) DATETIME FROM_MILLISECOND(BIGINT unix_timestamp) DATETIME FROM_MICROSECOND(BIGINT unix_timestamp)

将时间戳转化为对应的 DATETIME，传入的是整型，返回的是DATETIME类型。若unix_timestamp < 0 或函数结果大于 9999-12-31 23:59:59.999999，则返回NULL。

example

1. mysql> set time_zone='Asia/Shanghai';

3. mysql> select from_second(-1);
4. +---------------------------+
5. | from_second(-1)           |
6. +---------------------------+
7. | NULL                      |
8. +---------------------------+

10. mysql> select from_millisecond(12345678);
11. +----------------------------+
12. | from_millisecond(12345678) |
13. +----------------------------+
14. | 1970-01-01 11:25:45.678    |
15. +----------------------------+

17. mysql> select from_microsecond(253402271999999999);
18. +--------------------------------------+
19. | from_microsecond(253402271999999999) |
20. +--------------------------------------+
21. | 9999-12-31 23:59:59.999999           |
22. +--------------------------------------+

24. mysql> select from_microsecond(253402272000000000);
25. +--------------------------------------+
26. | from_microsecond(253402272000000000) |
27. +--------------------------------------+
28. | NULL                                 |
29. +--------------------------------------+

keywords

1. FROM_SECOND,FROM,SECOND,MILLISECOND,MICROSECOND