MySQL converts timestamps to date time

From_unixtime () is the time function in MySQL

Mysql>select from_unixtime (1249488000, '%y%m%d ')
20071120
Mysql>select from_unixtime (1249488000, '%y year%m month%d ')
November 2007

Directly converts a MySQL timestamp type to a date format

Unix_timestamp () is a time function that is opposite to it, converting datetime to timestamp type

Mysql> SELECT Unix_timestamp (); (Execution time: 2009-08-06-10:10:40)
->1249524739
mysql> SELECT unix_timestamp (' 2009-08-06 ');
->1249488000

MySQL converts timestamps to date time