oracle

select
‘YJ015‘quotaCode,CONCAT(‘00-‘,to_char(sysdate-1/24,‘HH24‘)) timeQuantum,count(1) quotaPresent
from
T_INVOICE_HISTORY
where
INVOICESTATE=1
and
APPLYDATE <![CDATA[ >= ]]> ‘2018-12-21 00:00:00‘
and
APPLYDATE <![CDATA[ <= ]]> sysdate-1/24

oracle

标签：tor   cat   count   from   sys   ant   sysdate   HERE   pre