0

I am receiving MySQL error 1265 when I try to insert records into a table and after googling this error I am no closer to understanding the problem.
Here is the error message that is returned:
Warning Code : 1265
Data truncated for column 'DATE_FIELD' at row 1

Here is the table definition:

CREATE TABLE  `test`.`TIME_TABLE` (
`RECORD_NUM` INT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT  'Number of Records',
`DATE_FIELD` DATE NOT NULL COMMENT  'Date of the event',
`DESCRIPTION` VARCHAR( 1000 ) NOT NULL COMMENT  'Detail of the event'
) ENGINE = MYISAM COMMENT =  'This day in history'

Here is a typical insert:
INSERT INTO TIME_TABLE ( DATE_FIELD, DESCRIPTION ) VALUES ('28, October    1971' , 'Great Britain launched Prospero, the first of four X-3 satellites.');

When inspecting the table the DATE-FIELD is set to ‘0000-00-00’

2
Contributors
2
Replies
5
Views
7 Years
Discussion Span
Last Post by rouse
0

You can insert a datefield as '1971-10-28'. The data you are trying to insert does not fit in the date column.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.