[Help]Sql error data truncation

[markg]

Salve,

durante l'operazione di Insert ad un certo punto l'inserimento di blocca e mi viene restituito il seguente errore:

SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000001' for column 'time' at row 1
SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000001' for column 'time' at row 1
SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000001' for column 'time' at row 1
SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000051' for column 'time' at row 1
SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000051' for column 'time' at row 1
SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000051' for column 'time' at row 1
SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000101' for column 'time' at row 1
SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000101' for column 'time' at row 1
SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000101' for column 'time' at row 1
SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000151' for column 'time' at row 1
SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000151' for column 'time' at row 1
SQL ERROR com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2007-11-21 17:11:56.001000151' for column 'time' at row 1

Vorrei sapere di cosa si tratta e come posso risolvere questo problema.

Grazie

[LeleFT]

Si tratta semplicemente che stai passando un valore DATA ad un campo TIME (che può contenere solo ore, minuti e secondi).

Ad ogni modo devo chiudere la discussione: Help non è un linguaggio... vedi Regolamento.


Ciao.