from_unixtime

    Convert the UNIX timestamp to the corresponding time format of bits, and the format returned is specified by string_format

    Currently, string_format supports following formats:

    Other string_format is illegal and will returns NULL.

    example

    1. mysql> select from_unixtime(1196440219);
    2. +---------------------------+
    3. | from_unixtime(1196440219) |
    4. +---------------------------+
    7. mysql> select from_unixtime(1196440219, '%Y-%m-%d');
    8. +-----------------------------------------+
    9. | from_unixtime(1196440219, '%Y-%m-%d')   |
    10. +-----------------------------------------+
    11. | 2007-12-01                              |
    12. +-----------------------------------------+
    14. +--------------------------------------------------+
    15. |From unixtime (1196440219,'%Y-%m-%d %H:%i:%s')    |
    16. +--------------------------------------------------+
    17. | 2007-12-01 00:30:19                              |
    18. +--------------------------------------------------+
    20. ## keyword