这是七天的量,只要写七条,如果是一个月岂不要写二三十条
AND
(J.HRSJ BETWEEN thisdate - 7 - 1 / 24 AND thisdate - 7
OR J.HRSJ BETWEEN thisdate - 6 - 1 / 24 AND thisdate - 6
OR J.HRSJ BETWEEN thisdate - 5 - 1 / 24 AND thisdate - 5
OR J.HRSJ BETWEEN thisdate - 4 - 1 / 24 AND thisdate - 4
OR J.HRSJ BETWEEN thisdate - 3 - 1 / 24 AND thisdate - 3
OR J.HRSJ BETWEEN thisdate - 2 - 1 / 24 AND thisdate - 2
OR J.HRSJ BETWEEN thisdate - 1 - 1 / 24 AND thisdate - 1)
AND
(J.HRSJ BETWEEN thisdate - 7 - 1 / 24 AND thisdate - 7
OR J.HRSJ BETWEEN thisdate - 6 - 1 / 24 AND thisdate - 6
OR J.HRSJ BETWEEN thisdate - 5 - 1 / 24 AND thisdate - 5
OR J.HRSJ BETWEEN thisdate - 4 - 1 / 24 AND thisdate - 4
OR J.HRSJ BETWEEN thisdate - 3 - 1 / 24 AND thisdate - 3
OR J.HRSJ BETWEEN thisdate - 2 - 1 / 24 AND thisdate - 2
OR J.HRSJ BETWEEN thisdate - 1 - 1 / 24 AND thisdate - 1)
第一步: 取J.HRSJ BETWEEN的精度为天进行限制
第二步:取J.HRSJ BETWEEN的精度为小时进行限制