creat view V_PERMIT
as
SELECT PERMIT.PERMITID, PERMIT.ITEMID, PERMIT.COMPANYCODE, PERMIT.PERMITNO, PERMIT.LOCATION,
PERMIT.BUILDAREA, PERMIT.PERMITAREA, PERMIT.SELLTYPE, PERMIT.NUMS, PERMIT.FLOORS, PERMIT.BUILDNO,
PERMIT.SETS, PERMIT.OUTAREA, PERMIT.OUTNUMS, PERMIT.OUTBUILDNO, PERMIT.OUTSETS, PERMIT.OUTNO,
PERMIT.INAREA, PERMIT.INNUMS, PERMIT.INBUILDNO, PERMIT.INSETS, PERMIT.PRICE, PERMIT.GIVEDATE,
PERMIT.STRUCTURE, PERMIT.[USE], PERMIT.STRUC1, PERMIT.STRUC2, PERMIT.STRUC3, PERMIT.STRUC4,
PERMIT.STRUC5, PERMIT.USE1, PERMIT.USE2, PERMIT.USE3, PERMIT.USE4, PERMIT.USE5, PERMIT.USE6,
PERMIT.USE7, PERMIT.USE8, PERMIT.OPENDATE, PERMIT.BUILDDATE, PERMIT.AGENTNAME, PERMIT.APPLYDATE,
PERMIT.CONSTRUCTUNIT, PERMIT.AGENTUNIT, PERMIT.REMARK, PERMIT.CONFIRMED, PERMIT.LOGINID,
PERMIT.NETWORKAREA, PERMIT.NETWORKSETS, PERMIT.CONSTRUCTNO, PERMIT.SELLTEL, PERMIT.SCALENO,
PERMIT.HOUSELOGID, PERMIT.LANDNO, PERMIT.CHECKFLAG, PERMIT.CHECKDATE, PERMIT.COMMITFLAG,
PERMIT.ALLFLOORS, PERMIT.ADDTJDATE, ITEM.DISTRICT,
ITEM.ITEM, COMPANY.COMPANYCODE AS Expr1, ITEM.BUILDUNIT, ITEM.ADDTJTIME, DATEDIFF(D, ITEM.ADDTJTIME, GETDATE()) AS ADDTJTIMED, COMPANY.COMPANY
FROM PERMIT INNER JOIN
ITEM ON PERMIT.ITEMID = ITEM.ITEMID INNER JOIN
COMPANY ON ITEM.COMPANYCODE = COMPANY.COMPANYCODE请问大虾 这有什么错误^
好像 DATEDIFF(D, ITEM.ADDTJTIME, GETDATE()) 这个在ORACLE中不可用,有没有大虾 帮我整体改一下?谢谢了
as
SELECT PERMIT.PERMITID, PERMIT.ITEMID, PERMIT.COMPANYCODE, PERMIT.PERMITNO, PERMIT.LOCATION,
PERMIT.BUILDAREA, PERMIT.PERMITAREA, PERMIT.SELLTYPE, PERMIT.NUMS, PERMIT.FLOORS, PERMIT.BUILDNO,
PERMIT.SETS, PERMIT.OUTAREA, PERMIT.OUTNUMS, PERMIT.OUTBUILDNO, PERMIT.OUTSETS, PERMIT.OUTNO,
PERMIT.INAREA, PERMIT.INNUMS, PERMIT.INBUILDNO, PERMIT.INSETS, PERMIT.PRICE, PERMIT.GIVEDATE,
PERMIT.STRUCTURE, PERMIT.[USE], PERMIT.STRUC1, PERMIT.STRUC2, PERMIT.STRUC3, PERMIT.STRUC4,
PERMIT.STRUC5, PERMIT.USE1, PERMIT.USE2, PERMIT.USE3, PERMIT.USE4, PERMIT.USE5, PERMIT.USE6,
PERMIT.USE7, PERMIT.USE8, PERMIT.OPENDATE, PERMIT.BUILDDATE, PERMIT.AGENTNAME, PERMIT.APPLYDATE,
PERMIT.CONSTRUCTUNIT, PERMIT.AGENTUNIT, PERMIT.REMARK, PERMIT.CONFIRMED, PERMIT.LOGINID,
PERMIT.NETWORKAREA, PERMIT.NETWORKSETS, PERMIT.CONSTRUCTNO, PERMIT.SELLTEL, PERMIT.SCALENO,
PERMIT.HOUSELOGID, PERMIT.LANDNO, PERMIT.CHECKFLAG, PERMIT.CHECKDATE, PERMIT.COMMITFLAG,
PERMIT.ALLFLOORS, PERMIT.ADDTJDATE, ITEM.DISTRICT,
ITEM.ITEM, COMPANY.COMPANYCODE AS Expr1, ITEM.BUILDUNIT, ITEM.ADDTJTIME, DATEDIFF(D, ITEM.ADDTJTIME, GETDATE()) AS ADDTJTIMED, COMPANY.COMPANY
FROM PERMIT INNER JOIN
ITEM ON PERMIT.ITEMID = ITEM.ITEMID INNER JOIN
COMPANY ON ITEM.COMPANYCODE = COMPANY.COMPANYCODE请问大虾 这有什么错误^
好像 DATEDIFF(D, ITEM.ADDTJTIME, GETDATE()) 这个在ORACLE中不可用,有没有大虾 帮我整体改一下?谢谢了
是不是改成(trunc(ITEM.ADDTJTIME)-trunc(sysDATE)) AS ADDTJTIME ???
可是我改了,还是提示SQL语句无效
DATEDIFF(D, ITEM.ADDTJTIME, GETDATE())
datediff是sql server中日期函数,oracle不支持,既然是求两者之间的天数,
在oracle中直接相减就可以了
GETDATE()-ITEM.ADDTJTIME