4 messages in com.mysql.lists.javaRe: Milleseconds information is gone?...| From | Sent On | Attachments |
|---|---|---|
| david joffrin | 08 Feb 2005 09:13 | |
| Rhino | 08 Feb 2005 09:29 | |
| Mark Matthews | 08 Feb 2005 10:13 | |
| Kevin A. Burton | 08 Feb 2005 10:57 |
| Subject: | Re: Milleseconds information is gone?!?!?! |
|---|---|
| From: | Mark Matthews (ma...@mysql.com) |
| Date: | 02/08/2005 10:13:26 AM |
| List: | com.mysql.lists.java |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Rhino wrote:
----- Original Message ----- From: "david joffrin" <davi...@hotmail.com> To: <ja...@lists.mysql.com> Sent: Tuesday, February 08, 2005 12:13 PM Subject: Milleseconds information is gone?!?!?!
Hi all,
I hope you can help!!! Current set-up: - A table using the TIMESTAMP field. - Usage of hibernate to access the DB and I have defined a field of type java.sql.Timestamp to map my TIMESTAMP column.
My object contains the right value (inc. milliseconds), but upon storage, the milleseconds are not being persisted in MySQL. Any idea that can help
me
please?
If I'm not mistaken, MySQL's JDBC driver does not store the milliseconds portion of the Timestamp.
Perhaps Mark Matthews, the developer of the JDBC driver, can verify that.
David,
Rhino is correct. The JDBC driver _can't_ store the milliseconds portion, because the server itself doesn't store it. If you need times with millisecond resoltuion, you should probably just store them as BIGINTs.
-Mark
- -- Mark Matthews MySQL AB, Software Development Manager - Client Connectivity www.mysql.com
MySQL User Conference (Santa Clara CA, 18-21 April 2005) Early registration until February 28: http://www.mysqluc.com/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCCQFctvXNTca6JD8RAgFTAJ45hhLMDsCpHLA044kSzxuQuEcaywCglKb7 8Hioh8qioy1xmPC3iUA8JPQ= =idc6 -----END PGP SIGNATURE-----