Getting error 1264 in mysql

Question

I am getting this error (1264 Out of range value for column 'estimate' at row 1) Does anyone know what this means as I am not to sure.

CREATE TABLE reading(
    meter_code CHAR(5) NOT NULL,
    `when` DATETIME NOT NULL,
    display DECIMAL(9,3) NOT NULL,
    estimate BIT NOT NULL DEFAULT 0,
    CONSTRAINT pri_reading 
PRIMARY KEY (`when`, meter_code),
    CONSTRAINT reading_FK
FOREIGN KEY (meter_code)
    REFERENCES meter (`code`) 
    ON UPDATE CASCADE 
    ON DELETE CASCADE );

This is what i am trying to insert.

INSERT INTO reading VALUES ('G1','2016.11.01','200','1');

Answer 1

BIT data type accepts only 0 and 1, b'0' and b'1' or 0b0 and 0b1. The string '1' is not a valid BIT value.

Also note that '2016.11.01' is not a valid DATETIME value. You should use either '2016-11-01' or '2016-11-01 00:00:00'.

Answer 2

Please increase the type length of your column "estimate" or change to string type