date(end_time) between '$(create_time1)' and '$(end_time1)'
括号错了
and CONVERT(varchar(10),end_time,120) between '${create_time1}' and '${end_time1}'