MYSQL int Type Date processing

Convert date format to int using Unix_timestamp ()

For example:
Select Now (), Unix_timestamp (now ());
Now () | Unix_timestamp (now ())
2014-11-28 09:54:43 | 1417139683

Use From_unixtime () to convert a date from an int type timestamp
For example:
Select Upt_time,from_unixtime (upt_time) from Drive_rel;
Upt_time | From_unixtime (Upt_time)
1336964014 | 2012-05-14 10:53:34
1361786530 | 2013-02-25 18:02:10
1284031294 | 2010-09-09 19:21:34

MYSQL int Type Date processing