13-bit timestamp in php + mysql

This article shares the 13-bit timestamp details in php + mysql.

function getMillisecond() {    list($t1, $t2) = explode(' ', microtime());    // return $t2 . '.' .  ceil( ($t1 * 1000) );    return $t2 . ceil( ($t1 * 1000) );}echo getMillisecond();

The above method can get a 13-bit timestamp and write it to the mysql table.

If the original time in the table is in the date format. Convert it like this.

For example, CU is a table. Mtime is a field with a 13-digit timestamp. Time is the original write time in the format of datatime.

update CU set mtime = UNIX_TIMESTAMP(time)*1000;

Appendix:

Function for converting UNIX timestamp to date: FROM_UNIXTIME ()

Select FROM_UNIXTIME (1156219870 );

Date to UNIX timestamp function: UNIX_TIMESTAMP ()

Select UNIX_TIMESTAMP ('2017-11-04 12:23:00 ′);

For example, the number of records queried by mysql on the current day:

$ SQL = "select * from message Where DATE_FORMAT (FROM_UNIXTIME (chattime), '% Y-% m-% d') = DATE_FORMAT (NOW (), '% Y-% m-% d') order by id desc ";

Of course, you can also switch in PHP.

UNIX timestamp to date function: date ()

Date ('Y-m-d H: I: S', 1156219870 );

Date to UNIX timestamp function: strtotime ()

Strtotime ('2017-03-24 08:15:42 ');

The above is a detailed description of the 13-bit timestamp in php + mysql. For more information, see other related articles in the first PHP community!