摘要：
select 'YJ015'quotaCode,CONCAT('00-',to_char(sysdate-1/24,'HH24')) timeQuantum,count(1) quotaPresent from T_INVOICE_HISTORY where INVOICESTATE=1 and A 阅读全文
摘要：
select sysdate,sysdate + 1/24 from dual; 加1小时 select sysdate,sysdate - 1/24 from dual; 减1小时 trunc(sysdate-1) 日期截取 2018/12/24 阅读全文