MySQL: Get current time with milliseconds

[riahc3]

Oldest question in the book.

Google says:

SELECT NOW()+ 0;

And a bunch of other things like UNIX_TIMESTAMP() but doing a select on these, it only returns the seconds, not including the miliseconds.

Basically, I need, from MySQL's side the milliseconds. How can I do this?

[Reverend Jim]

 CURTIME([fsp])

As of MySQL 5.6.4, if the fsp argument is given to specify a fractional seconds precision from 0 to 6, the return value includes a fractional seconds part of that many digits. Before 5.6.4, any argument is ignored.

[cereal]

In addition, you could try with a UDF. For example:

• http://www.xaprb.com/blog/2007/10/30/how-i-built-the-now_usec-udf-for-mysql/
• http://stackoverflow.com/a/8986802

But if you want to save it, you have to use varchar instead of a datetime column.

[riahc3]

Intresting: Im running 5.5.35 on Ubuntu...

Is 5.6.x stable? Ill upgrade to it if neccesary (as long as it doesnt mess anything up)