|
| Re: milliseconds in mySQL |
 |
Mon, 18 Feb 2008 21:56:38 +000 |
On Mon, 18 Feb 2008 22:27:32 +0100, zgb wrote:
> Is it possible to store the time in milliseconds format?
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@arvin.dk>
|
| Post Reply
|
| milliseconds in mySQL |
 |
Mon, 18 Feb 2008 22:27:32 +010 |
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.
|
| Post Reply
|
| Re: milliseconds in mySQL |
 |
Mon, 18 Feb 2008 23:38:36 +010 |
Troels Arvin wrote:
> On Mon, 18 Feb 2008 22:27:32 +0100, zgb wrote:
>> Is it possible to store the time in milliseconds format?
>
> No. With MySQL, you will have to invent your own system for this, such as
> storing the fractional seconds in a separate integer column.
>
Well it's not handy for me to store data like that because i have to do
some summation/substraction with those values.. But thank you very much
|
| Post Reply
|
|
|
|
|
|
|
|
|
|