Mysql date-type and int-type interchange method _mysql

The date type converts to an int type

Unix_timestamp (' 1997-10-04 22:23:00 ') =====> 875996580

Two, int type converts to date type

From_unixtime (875996580) =====> ' 1997-10-04 22:23:00 '

PHP to convert int data to date output
echo Date (' y-m-d ', $date);
PHP inside the date data output:
Echo $date;
PHP converts date data to int:
Strtotime ($date);

The above is a small series for everyone to bring the MySQL date and int-type interchange method all content, I hope that we support cloud-Habitat Community ~