milliseconds in mysql

Question

This page explains how to format milliseconds http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_now

but how do I get the actual millisecond value beyond just .00000?

I've tried these:

  select unix_timestamp()+0;
  select SYSDATE()+0;
  select date_format(now(), '%f');
  select now()+0;

but none of theme give me precise and accurate milliseconds

Answer 1

Maybe this one helps: http://bytes.com/topic/mysql/answers/864643-how-get-milliseconds#post3467585