sql - MySQL Incorrect datetime value: '09:40 AM' for column -
I try to enter values in the table and I get this error
" Wrong date time value: '09: 40am 'for column' '
make table class (CRN four (5) tap primary key, not duplicate char (3) Course_NUl Char (3) No meeting, meeting_de varchar (6) tap, start_time datetime null, end_time varchar (8) tap, campus_code varchar (3) tap, location varchar (6) tap, faculty_id four (4) tap, nomination Zero, capacity TINYINT faucet,); Enter the class in values ('20761', 'PSY', '101', 'MW', '09: 40 AM ') (CRN, DIPTOCOD, COURSE_NEM, MEETING_DE, START_time, AND_time, campus_code, location, faculty_ID, Nomination , Ability), '11: 10 o'clock ',' WC ',' E-527 ',' F002 ', 40, 40);
thanks
Use Time Datat
And you used the comma at the end of the column when creating the table
Make the address of the table class (crn char (5) not the primary key, Dept_code char (3) no tap, course_NOR (3) no tap, meeting_devitter (6) tap, time-time time nell, and_time time nail, campus_code varchar (3) tap, location varchar (6) tap, faculty_id four 4) Faucet, Nomination TINYINT Faucet, Capacity Tin Does not have internet faucet); Class Entry (CRN, DipCode, Course_NUM, Meeting_day, Start_time, End_time, Campscode, Location, Faculty_ID, Nomination in Price Work ('20761', 'PSY', '101', 'MW', '09: 40: 00) , Ability), '11: 10: 00 ',' WC ',' E-527 ',' F002 ', 40, 40);
Comments
Post a Comment