Re: how to get (lapse) time in microseconds ?

[Chris White]

C.R.Vegelin wrote:

Hi List,

I need the lapse time in microseconds.
I have tried various things, like:
SELECT TIME_FORMAT(CURTIME(), '%f');
SELECT TIME_FORMAT(NOW(), '%f');

Your arguments are reversed.  It's:

SELECT TIME_FORMAT('%f',CURTIME());
SELECT TIME_FORMAT('%f',NOW());

SELECT MICROSECOND(CURTIME());

Don't know about this one though.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]