开发者

Incorrect Date Exception

I am trying to enter a date with year 1900 using java into sql, but I am getting exception as :

com.mysql.jdbc.MysqlDataTruncation: Data truncation:开发者_开发知识库 Incorrect datetime value: '1900-01-01 00:00:00'


If you are using TIMESTAMP to store the dates the minimal value is '1970-01-01 00:00:01'.

Use DATE to store older dates or DATETIME to store older dates with time.

Check the MySQL documentation about the date format http://dev.mysql.com/doc/refman/5.1/en/datetime.html

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜