如何在日期和时间之间运行查询？

也许是这样的：

 AND ( A1.CHDLM = 20110505        AND A1.CHTLM >= '160000'      OR       A1.CHDLM = 20110506       AND A1.CHTLM <= '130000'     )

为了更笼统（以捕捉两个日期不连续的情况），应为：

 AND ( A1.CHDLM = 20110505        AND A1.CHTLM >= '160000'      OR       A1.CHDLM BETWEEN 20110505 +1         AND 20110506 -1     OR       A1.CHDLM = 20110506       AND A1.CHTLM <= '130000'     )