This discussion is archived
2 Replies Latest reply: Jul 19, 2013 6:11 AM by robleh7 RSS

trunc() replacing datediff from MS SQL Server

robleh7 Newbie
Currently Being Moderated

I've been able to successfully replace the MS SQL func datediff with Oracle's trunc() for a dB at my firm. Now a slight problem occurs when I try to tweek it. Here is the generic code w/o any company references (my firm is very strict about leaking proprietary info).

 

SELECT createdate, TransactionDtTm, id, objid,

trunc((createdate- start_date) <=0))

FROM TBL1, TBL2

where active =1;

This query runs fine w/o the <=0. With this parameter added I get an ORA 00907 error. But I do have closing parenthesis.

 

Any suggestions would be appreciated.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points