MySQL Forums
Forum List  »  Newbie

1292 Incorrect time value
Posted by: slava shapiro
Date: September 11, 2016 03:22PM

hi every one.
I have a problem with my work on MySQL workbench.
I build a schema called market and create tree table, store table; time table; day off table, the first table work perfect the problem start in the second table when I type INSERT INTO `market`.`time` (`idt`, `time`, `day`) VALUES ('1', '08:00 - 22:00 ', 'sunday to tuesday');
I get thet error Executing:
INSERT INTO `market`.`time` (`idt`, `time`, `day`) VALUES ('1', '08:00 - 22:00 ', 'sunday to tuesday');

ERROR 1292: 1292: Incorrect time value: '08:00 - 22:00 ' for column 'time' at row 1
SQL Statement:
INSERT INTO `market`.`time` (`idt`, `time`, `day`) VALUES ('1', '08:00 - 22:00 ', 'sunday to tuesday')


Operation failed: There was an error while applying the SQL script to the database.
so if any one have a solution for that ishyuo I will be happy get one.
thanks for advance.

Options: ReplyQuote


Subject
Written By
Posted
1292 Incorrect time value
September 11, 2016 03:22PM
September 12, 2016 08:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.