0

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?

3
Contributors
3
Replies
12
Views
3 Years
Discussion Span
Last Post by riahc3
1
 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.

0

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)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.