MySQL Time conversion function

Unix_timestamp "2009-09-15 00:00:00" converted to a function classified as a long integer type

Select unix_timestamp("2013-03-15 00:00:00") *1000, it is important to note that the long integer in the MySQL database is less than the number of milliseconds behind the long integer in Java, so multiply by 1000. It's only a few milliseconds.

From_unixtime "1252999488" (Long data in Java) converted to date

Select from_unixtime(1252999488); "Note": To remove the last three bits. From_unixtime (1388776825, '%y%m%d ') customizable time format

MySQL Time conversion function