客户是ORACLE数据库，做账表的时候日期相减在前端显示异常，同样的代码在数据库区是正确的，有哪位大佬知道是什么原因啊？

前端：

前端显示.png

数据库：

日期数据库相减.png

代码：

/*dialect*/Create table {0} as select FBILLNO,FSUPPLIERNAME,FCERTORIGINAL,FMATERIALNUMBER,FMATERIALNAME,

FDATE,NVL(FQTY,0) AS FQTY,NVL(FQTY,0) AS FPLANQTY,NVL(FQTY,0) AS FCONFIRMDELIQTY,FHTZBILLNO,NVL(FREALQTY,0) AS FREALQTY,

F_PAEZ_DATE AS FCONFIRMDELIDATE,FREALDATE,FDELIVERYDATE,

FCUSTOMERDELAYDATE,

FDELAYDATE,

{1}

from(

select A.FBILLNO,C.FNAME FSUPPLIERNAME,B.FCERTORIGINAL,D.FNUMBER FMATERIALNUMBER,E.FNAME FMATERIALNAME,

A.FDATE,B.FQTY,F.FDELIVERYDATE,B.F_PAEZ_DATE,G.FHTZBILLNO,G.FREALQTY,G.FREALDATE,

TO_NUMBER(ceil(to_date(G.FREALDATE,'yyyy-mm-dd hh24-mi-ss')-to_date(F.FDELIVERYDATE, 'yyyy-mm-dd hh24-mi-ss'))) FCUSTOMERDELAYDATE,

TO_NUMBER(ceil(to_date(G.FREALDATE,'yyyy-mm-dd hh24-mi-ss')-to_date(B.F_PAEZ_DATE,'yyyy-mm-dd hh24-mi-ss'))) FDELAYDATE

FROM t_PUR_POOrder A --采购订单

LEFT JOIN t_PUR_POOrderENTRY B ON A.FID=B.FID --采购订单明细

LEFT JOIN T_BD_SUPPLIER_L C ON A.FSUPPLIERID=C.FSUPPLIERID AND C.FLOCALEID=2052 --供应商资料

LEFT JOIN T_BD_MATERIAL D ON B.FMATERIALID=D.FMATERIALID --物料资料

LEFT JOIN T_BD_MATERIAL_L E ON B.FMATERIALID=E.FMATERIALID AND E.FLOCALEID=2052 --物料资料

LEFT JOIN T_PUR_POORDERENTRY_D F ON B.FENTRYID=F.FENTRYID --采购订单交货信息

LEFT JOIN (

SELECT A.FBILLNO FHTZBILLNO,FDATE FREALDATE,B.FMUSTQTY FREALQTY,C.FSBILLID,C.FSID

FROM T_PUR_Receive A --收料通知单

LEFT JOIN T_PUR_ReceiveEntry B ON A.FID=B.FID --收料通知单明细

LEFT JOIN T_PUR_ReceiveEntry_LK C ON B.FENTRYID=C.FENTRYID --收料通知单关联关系

WHERE FSTABLENAME='t_PUR_POOrderEntry' AND A.FDOCUMENTSTATUS='C' AND A.FCANCELSTATUS='A' --只取上游单据是采购订单

) G ON B.FID=G.FSBILLID AND B.FENTRYID=G.FSID

WHERE A.FDOCUMENTSTATUS='C' AND A.FCANCELSTATUS='A' AND A.FPURCHASEORGID='101755'

)T

WHERE T.FREALDATE BETWEEN to_date('{2}', 'yyyy-mm-dd hh24:mi:ss') AND to_date('{3}','yyyy-mm-dd hh24:mi:ss')

产品问题ORACLE数据库日期相加显示异常

产品问题 ORACLE数据库日期相加显示异常