java mysql 时间不对_MySQL / Java：日期值不正确：列的’1990′

使用Java在MySQL中输入日期时遇到了一个顽固的问题.在我的代码中,我将java.util.Date转换为java.sql.Date,以便快速轻松地匹配日期的SQL格式.

下面是我用来将日期插入数据库的代码.注意：代码缩短为仅表达我的问题.

客户端对象通过函数的参数传递.

//Date to Date

java.sql.Date sqlBirthday = new java.sql.Date(client.getBirthday().getTime());

System.out.println(sqlBirthday); // Prints YYYY-MM-DD

sql = "INSERT INTO clientdata (client_id, weight, height, birthday) VALUES (" + client.getID() + "," + client.getWeight() + "," + client.getHeight().getMeasurementInInches() + ","

+ sqlBirthday + ")";

statement.execute(sql);

statement.close();

执行代码将数据输入数据库后,我收到以下运行时错误：

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: ‘1990’ for column ‘birthday’ at row 1

println输出以下内容：

1998-05-03

这是预期的产出.

错误的堆栈跟踪如下,但我怀疑它有多大用处：

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: '1990' for column 'birthday' at row 1

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3833)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)

at fitness.traingym.client.utils.DatabaseHandler.createLogin(DatabaseHandler.java:71)

at fitness.traingym.client.TrainManagement.testClientCreate(TrainManagement.java:47)

at fitness.traingym.client.TrainManagement.(TrainManagement.java:22)

at fitness.traingym.client.TrainManagement.main(TrainManagement.java:57)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at com.intellij.rt.execution.application.AppMain.main(AppMain.java:134)

这很有趣我遇到了这个错误,因为日期的格式似乎对SQL语法是正确的.