Home:ALL Converter>MySQL UNIX_TIMESTAMP(now()) - current time in milliseconds

MySQL UNIX_TIMESTAMP(now()) - current time in milliseconds

Ask Time:2018-01-04T23:12:36         Author:Yaniv Peretz

Json Formatter

Is there a MySQL way to query based on current MySQL time in milliseconds?

I'm trying:

SELECT UNIX_TIMESTAMP(), UNIX_TIMESTAMP(NOW()) as now_in_mili

but both columns return the same (the 1970 epoch time).

I'm expecting 'now_in_mili' to print current date in milliseconds such as it is possible in JavaScript:

Date.parse(new Date())

Author:Yaniv Peretz,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/48098185/mysql-unix-timestampnow-current-time-in-milliseconds
yy