and CONVERT(datetime,SUBSTRING(a.DeliveryDate, 1, 10),101) >= CONVERT(datetime,SUBSTRING(#{startTime}, 1, 10),101)
and CONVERT(datetime,SUBSTRING(#{endTime}, 1, 10),101) >= CONVERT(datetime,SUBSTRING(a.DeliveryDate, 1, 10),101)
and CONVERT(datetime,SUBSTRING(a.DeliveryDate, 1, 10),101) >= CONVERT(datetime,SUBSTRING(#{startTime}, 1, 10),101)
and CONVERT(datetime,SUBSTRING(#{endTime}, 1, 10),101) >= CONVERT(datetime,SUBSTRING(a.DeliveryDate, 1, 10),101)