Get the current time with millisecond precision

SELECT NOW(3)

does the trick.