MySQL Time with subsecond precision Get the current time in a form that looks like a Javascript timestamp.
Example
Javascript timestamps are based on the venerable UNIX time_t data type, and show the number of milliseconds since 1970-01-01 00:00:00 UTC.
This expression gets the current time as a Javascript timestamp integer. (It does so correctly regardless of the current time_zone setting.)
ROUND(UNIX_TIMESTAMP(NOW(3)) * 1000.0, 0)
If you have TIMESTAMP values stored in a column, you can retrieve them as integer Javascript timestamps using the UNIX_TIMESTAMP() function.
SELECT ROUND(UNIX_TIMESTAMP(column) * 1000.0, 0)
If your column contains DATETIME columns and you retrieve them as Javascript timestamps, those timestamps will be offset by the time zone offset of the time zone they're stored in.
