How to convert a MYSQL timestamp to a common time format

How to convert the MYSQL timestamp to the general time format UNIX_TIMESTAMP (date)? If no parameter is called, a Unix timestamp (the number of seconds since '2017-01-01 00:00:00 'GMT) is returned ). If UNIX_TIMESTAMP () is called with a date parameter, it returns the second value starting from '2017-01-01 00:00:00 'GMT. Date can be a number of a DATE string, a datetime string, a TIMESTAMP, or a local time in YYMMDD or YYYYMMDD format. Www.2cto.com mysql> select UNIX_TIMESTAMP ();-> 882226357 mysql> select UNIX_TIMESTAMP ('2017-10-04 22:23:00 ');-> 1997 when UNIX_TIMESTAMP is used in a TIMESTAMP column, the function will directly accept the value without the implicit "string-to-unix-timestamp" transformation. Www.2cto.com FROM_UNIXTIME (unix_timestamp) returns the value represented by the unix_timestamp parameter in 'yyyy-MM-DD HH: MM: ss' or YYYYMMDDHHMMSS format, it depends on whether the function is used in a string or a number context. Mysql> select FROM_UNIXTIME (875996580);-> '2017-10-04 22:23:00 'mysql> select FROM_UNIXTIME (1997) + 0;-> 875996580 FROM_UNIXTIME (unix_timestamp, format) returns a string representing the Unix time mark, formatted according to the format string. Format can contain the same modifier as the entries listed by the DATE_FORMAT () function. Mysql> select FROM_UNIXTIME (UNIX_TIMESTAMP (), '% Y % D % M % h: % I: % s % x '); -> Xie chunye, author of '2014 23rd December 03:43:30 x'