TP5多表联查时时间between问题

a.	$map[] = ['a.create_time', 'between', ['2020-10-01', '2020-10-02']];
b.	$map[] = ['a.create_time', 'between time', ['2020-10-01', '2020-10-02']];

A. 	Db::name('student_answer')->alias('a') 
B. 	Db::name('student_answer a') 

a + A 	:	ok
b + A 	:	ok
a + B 	: 	ok
b + B	: 	err

结论: between 和 between time 字段解析问题

解决:1.使用between
     2.使用alias

推荐 2
相关推荐
©️2020 CSDN 皮肤主题: 游动-白 设计师:白松林 返回首页