Examples of MySQL conversion timestamp

MySQL transition timestamp, directly let the MySQL statement display time or time stamp form.

Convert Time to Timestamp

The code is as follows	Copy Code
Select Unix_timestamp (' 2014-1-1 00:00:00′)

If the parameter is empty, it is processed as the current time, showing the current time

Convert time stamp to time

The code is as follows	Copy Code
Select From_unixtime (12345678912)

Some applications generate a timestamp that is three bit more than this, is milliseconds, if you want to convert, you need to first remove the last three bits, otherwise display null

From_unixtime (Unix_timestamp,format)

Returns a String representing the Unix time token, formatted according to the format string. FORMAT can contain the same modifiers as the entries listed in the Date_format () function.