DateTime Milliseconds Issue

[Palin Patzke]

Hallo together,

form my application I need a DateTime with milliseconds. Due the millisecond in DateTime are supported with the 5.6.4. version of the mysql Database. I have make a export with MySQL Workbench of the Database. Deinstall the old Version (5.0.95) and Install the new Version (5.6.16). After this I import the Data.

To Test, if the milliseconds works I alter a existing value with:

UPDATE DB.TraceState
set `DateTime` = 20090922201843.426
where tblTraceState_ID = 1 ;

And select the milliseconds value with:

SELECT Microsecond(DateTime) FROM DB.TraceState
where tblTraceState_ID =1;

The result is 0, but I expect 426.

Is there anything further I must do to get milliseconds support with the database.

Regards,
Palin

p.s. please excuse my terrible English, I am not a native speaker.