Ora-00905: Missing Keyword

[cade 0]

CODE

SELECT
BRNCD AS BRANCH, CRLINE || "/" || FCCD || "/" || PRLINE || "/" || PRTYP AS PRODUCT, BRNCD, MODCD, ACNO, CHKDGT,
CERTYR || "/" || CERTNO AS CERTNO, PRCAMT AS PRIN_AMT, ISSDT AS ISSDT, EFFDT AS EFFDT, DUEDT AS DUEDT, CAST(DateDiff(dd, ISSDT,
DUEDT)) AS NODAYS, PERIOD AS TENOR, INTRT AS RATE, TOTINT AS TOTINT, INTPAID AS INTPAID, WHTAX AS WTAX, TOTACCR AS INTACCR
FROM   FD02CERT
WHERE     (EFFDT >= TO_DATE('01/01/2000', 'DD/MM/YYYY')) OR
                      (EFFDT <= CAST(GETDATE()))
ORDER BY ISSDT, EFFDT

aku run ni guna DTS tp SQL ni akan amik data dari DB oracle 10g....tp aku still ada error ORA-00905: Missing keyword....

ada sesapa yg experience camni tk?

[cade 0]

ok da tau da ape masalah nyer.....aku guner sql kat atas utk amik data dr oracle...so sql tu mesti compliance dgn oracle...datediff bkn function dari oracle..so kena tukar skit....

CODE

SELECT
FD02CERT.BRNCD AS Branch,
FD02CERT.CRLINE || '/' || FD02CERT.FCCD || '/' || FD02CERT.PRLINE || '/' || FD02CERT.PRTYP AS Product,
FD02CERT.BRNCD || '/' || FD02CERT.MODCD || '/' || FD02CERT.ACNO || '/' || FD02CERT.CHKDGT AS Acct No,
CF01CIF.LNAME,
FD02CERT.CERTYR || '/' || FD02CERT.CERTNO AS CertNo,
FD02CERT.PRCAMT AS PrincipalAmount,
FD02CERT.ISSDT AS IssueDate,
FD02CERT.EFFDT AS EffectiveDate,
FD02CERT.DUEDT AS DueDate,
to_date(FD02CERT.DUEDT, 'dd-mm-yyyy')-to_date(FD02CERT.ISSDT, 'dd-mm-yyyy') AS NODAYS,
FD02CERT.PERIOD AS Tenor,
FD02CERT.INTRT AS Rate,
FD02CERT.TOTINT AS TotalInterest,
FD02CERT.INTPAID AS IntPaid,
FD02CERT.WHTAX AS WTax,
FD02CERT.TOTACCR AS IntAccrued
FROM MBSBPROD_FD02CERT
INNER JOIN
(CF01CIF INNER JOIN FD01MAST ON CF01CIF.CIFKEY = FD01MAST.CIFKEY)
ON
(FD02CERT.CHKDGT = FD01MAST.CHKDGT) AND (FD02CERT.ACNO = FD01MAST.ACNO) AND (FD02CERT.MODCD = FD01MAST.MODCD) AND (FD02CERT.BRNCD = FD01MAST.BRNCD)
WHERE FD02CERT.EFFDT >= TO_DATE('01-01-2000', 'dd-mm-yyyy') AND FD02CERT.EFFDT <= SYSDATE
ORDER BY FD02CERT.ISSDT, FD02CERT.EFFDT;

ni sample sql yg aku ada...susah gak DTS nih...fuhh