Mysql time conversion statement

Mysql time conversion statement mysql> select UNIX_TIMESTAMP ();-> 882226357 mysql> select UNIX_TIMESTAMP ('2017-10-04 22:23:00 ');-> 1997 when UNIX_TIMESTAMP is used for a TIMESTAMP column, the function will directly accept the value without the implicit "string-to-unix-timestamp" transformation. FROM_UNIXTIME (unix_timestamp) www.2cto.com 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