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

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

eclipse plugin - Run java code error: Workspace is closed -

c - Error on building source code in VC 6 -