Hi, I'm using mySQL version 5.0.45.
Is it possible to store the time in milliseconds format?
I've tried with TIMESTAP and DATETIME column types, it doesn't work.
With TIME column type I can put value up to microsecond - etc.
14:02:01.199999 but when i refresh the table data everything after
decimal point is gone, result is 14:02:01
I've also tried mySQL version 5.1, same thing.

Best regards

On Mon, 18 Feb 2008 22:27:32 +0100, zgb wrote:
No. With MySQL, you will have to invent your own system for this, such as
storing the fractional seconds in a separate integer column.

--
Regards,
Troels Arvin <troels (AT) arvin (DOT) dk>
http://troels.arvin.dk/

On Mon, 18 Feb 2008 22:27:32 +0100, zgb wrote:
No. With MySQL, you will have to invent your own system for this, such as
storing the fractional seconds in a separate integer column.

--
Regards,
Troels Arvin <troels (AT) arvin (DOT) dk>
http://troels.arvin.dk/

On Mon, 18 Feb 2008 22:27:32 +0100, zgb wrote:
No. With MySQL, you will have to invent your own system for this, such as
storing the fractional seconds in a separate integer column.

--
Regards,
Troels Arvin <troels (AT) arvin (DOT) dk>
http://troels.arvin.dk/

Troels Arvin wrote:
some summation/substraction with those values.. But thank you very much
for your reply, it was very helpful.

Troels Arvin wrote:
some summation/substraction with those values.. But thank you very much
for your reply, it was very helpful.

Troels Arvin wrote:
some summation/substraction with those values.. But thank you very much
for your reply, it was very helpful.