The interchange method between mysql date and int type, mysqldate

The interchange method between mysql date and int type, mysqldate

1. Convert date type to int type

UNIX_TIMESTAMP ('2017-10-04 22:23:00 ') ===> 1997

Ii. Convert int type to date type

FROM_UNIXTIME (875996580) ===> '2017-10-04 22:23:00'

PHPConvert int type data to date output
Echo date ('Y-m-d', $ date );
Output date data in PHP:
Echo $ date;
In PHP, convert data of the date type to the int type:
Strtotime ($ date );

The above is all the mysql date-date and int-type interchange methods provided by the mini-editor. I hope you can support more customers ~