for example :
create table test (id int primary key auto_increment,name varchar(20),joining_time Time);
now i have my table test, in that test i am trying to insert some values
insert into test (id,name,joining_time ) values (default,"randomuser","12:20:12 PM");
this query has an error that joining_date is in date format
so my doubt is can we insert time with AM/PM specifications in insert query
if we can't please explain me why ?
i knew that we can retrieve