Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Databases General > milliseconds in...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 3106 of 3210
Post > Topic >>

milliseconds in mySQL

by zgb <zgb23@[EMAIL PROTECTED] > Feb 18, 2008 at 10:27 PM

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
 




 3 Posts in Topic:
milliseconds in mySQL
zgb <zgb23@[EMAIL PROT  2008-02-18 22:27:32 
Re: milliseconds in mySQL
Troels Arvin <troels@[  2008-02-18 21:56:38 
Re: milliseconds in mySQL
zgb <zgb23@[EMAIL PROT  2008-02-18 23:38:36 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 0:56:28 CDT 2008.