How do I store date and time with miliseconds in MySQL?

[riahc3]

Hey

Im looking to store date and time with miliseconds in TIMESTAMP column but it seems to be a new feature so Im not sure exactly how to store it. current_timestamp() doesnt allow me to do this.

Im willing to change the column to some other datatype as the database is new and for now, nothing depends on it.

How can I do it?

Thanks

[pritaeas]

Known bug, for work-arounds see: http://stackoverflow.com/questions/2166008/is-it-possible-to-compare-a-mysql-timestamp-to-a-millisecond