NOW() with milliseconds?

japhy1 · #1 (**permalink**) 08-21-07, 10:27

Is there any function within MySQL that can return the current time with millisecond resolution. NOW() only returns the integer number of seconds...

Thanks in advance.

gvee · #2 (**permalink**) 08-21-07, 10:58

Would this help?

japhy1 · #3 (**permalink**) 08-21-07, 11:04

i don't think so, it says you can return the milliseconds from an argument but there's nothing related to NOW() or CURTIME() with finer resolution than seconds

I'm looking at this right now for help.

http://bugs.mysql.com/bug.php?id=8523

gvee · #4 (**permalink**) 08-21-07, 11:11

Ah: http://jacqueschirag.wordpress.com/2...tgresqloracle/

japhy1 · #5 (**permalink**) 08-21-07, 11:18

not using postgresql or oracle.

what the best way to compile and use a UDF on a windows platform?

gvee · #6 (**permalink**) 08-21-07, 11:22

Quote:

Originally Posted by The link I posted

MySQL

It turns out that MySQL does not support sub-second time or date formats. There is a MICROSECOND function in MySQL allowed to run on temporal values, but sub-second precision (including millisecond) is not stored in the database.

The message I have entered is too short...

japhy1 · #7 (**permalink**) 08-21-07, 14:24

not sure what the point of your last reply was...

anyway, I found a method. I created a dll using Visual C++ .NET 2005. I then turned the dll into a UDF...all the UDF did was get the current system time's millisecond value using the C++ SYSTEMTIME structure. I then added this to the number of seconds you can get using the UNIX_TIMESTAMP and NOW() functions in SQL. Store it as a DOUBLE PRECISION and voila you've got a current UTC time with millisecond resolution.

relevant link:

http://www.codeguru.com/cpp/data/mfc...p/c12615/#more

Internet Services

Web Development

Digital Marketing

Consumer Tech