Question

java中的date格式数据，在mapper中插入mysql的datetime类型字段时sql怎么写

Answer 1

insert into a(name,time) values(#{name},now())或者
insert into a(name,time) values(#{name},#{time})

Answer 2

insert into abc(id,date_time) values (1,'2018-08-08 12:12:12');