AND t2.activity_start_time
<= STR_TO_DATE(#{validtime},’%Y-%m-%d’)
AND t2.activity_stop_time
>= STR_TO_DATE(#{validtime},’%Y-%m-%d’)
mybatis查询条件,比较时间时
最新推荐文章于 2024-04-26 15:26:20 发布
AND t2.activity_start_time
<= STR_TO_DATE(#{validtime},’%Y-%m-%d’)
AND t2.activity_stop_time
>= STR_TO_DATE(#{validtime},’%Y-%m-%d’)