GET milliseconds with DATE_FORMAT in mysql

If you really want use DATE_FORMAT you can do this:

SELECT SUBSTRING(DATE_FORMAT(NOW(3), '%d-%b-%y %H:%m:%s.%f'),1,22);