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
精彩评论