>>>When I do a insertion of a record I want to save not only the Timestamp like "HH;MM;SS" but I also want to store the microsecond part, since in 1 second a machine can store multiple records, ant I want to distinguish them by milli or microsecond.
>>
>>Why don't you let mysql handle it?
>>
>>
>>... ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
>>
>
>It doesn't appear that MySQL's Timestamp has precision below seconds..?
In that case OP will have to store datetime value as a string in order to preserve milliseconds part
--sb--