vrijdag 25 juni 2010

MySQL datatype for PHP microtime()

Ok, this has probably been already solved by just about everyone on the world-wide-web.... Well, count me out then....

Until just now i was trying to put a microtime(true) result in a float(20.4) field....

Which simply doesnt work on MySQL 5.1 (at least not in my case, since all values after the decimalseparationcharacter are .0000)....

Try a field type named double(20,4) and it works like a charm....

And out.

Geen opmerkingen: