A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
truncation errors storing a Date in MySQL table
Joined: Sep 01, 2009
Oct 01, 2009 04:26:15
I have a 'timestamp' field in a mysql table.
when I attempt to insert a Date into the table. Like this:
Date currentTime = new Date(new java.util.Date().getTime()); queryString = "INSERT INTO example_table (timestamp) VALUES ('" + currentTime + "')" connection.exectuteUpdate(queryString )
I get the error: Data truncation: Incorrect datetime value: 'Thu Oct 01 11:08:57 BST 2009'
I've tried changing the timestamp field to DATETIME, TIMESTAMP and DATE but to no avail.
What am I doing wrong?
Joined: Dec 20, 2006
Oct 01, 2009 14:18:15
and set the time with setDateTime();
If you would print your sql statement before executing it, you would see why it fails. The value of currenTime is not what you expect.
OCUP UML fundamental and ITIL foundation
subject: truncation errors storing a Date in MySQL table
MySQL - Date/Time and Timestamp Issues
gps week/seconds conversion
MySQL DATE_FORMAT for INSERT
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013