Warning (Code 1264): Out of range value for column 'HireDate' at row 1 in sql

Question

insert into Employee values(2,"Brown","Barry",2011-08-12,1,11,null); Query OK, 1 row affected, 1 warning (0.00 sec) Warning (Code 1264): Out of range value for column 'HireDate' at row 1 what does this mean in sql guys???

Possible duplicate of Warning#1264:out of range error in mysql — nacho
– nacho, Commented Jun 13, 2017 at 9:41
it means Your data is not valid for this column. Too long or different type. — Whencesoever
– Whencesoever, Commented Jun 13, 2017 at 9:41

RiggsFolly · Accepted Answer · 2017-06-13 11:35:48Z

Quite simply, when entering a date into a query it must be wrapped in quotes as it is considered to be a text string.

insert into Employee values(2,"Brown","Barry",'2011-08-12',1,11,null);

Collectives™ on Stack Overflow

Warning (Code 1264): Out of range value for column 'HireDate' at row 1 in sql

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related