Issues with Oracle SQL syntax error for DATE_SUB

Question

I'm getting a "missing right parenthesis" error with the below query. I do not have a missing parenthesis....

I tried looking at the oracle sql documentation and do not see where there is an issue.

The query is

select *
  from DB.DB
 where OUTAGE_OPENED > DATE_SUB(NOW(), INTERVAL 60 MINUTE)

The full error is

ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis" *Cause:
*Action: Error at Line: 25 Column: 48

Column 48 is where I have the 60.

I've tried SUBDATE(the documentation says they are the same when using the arguments I am using). This works in mysql, and it seems like it should work in oracle, but obviously I'm doing something wrong.

Gordon Linoff · Accepted Answer · 2019-10-26 13:00:11Z

3

date_sub() is not an Oracle function. Just use intervals:

SELECT * 
FROM DB.DB
WHERE OUTAGE_OPENED > sysdate - INTERVAL '60' MINUTE;

answered Oct 26, 2019 at 13:00

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bob Jarvis - Слава Україні · Accepted Answer · 2019-10-26 14:08:06Z

0

DATE_SUB is available in MySQL but not in Oracle. Although both of these databases are Oracle Corporation products (now) they are the results of completely different development lines (you might compare the history of both products) and thus have major differences, such as their handling of dates and times.

answered Oct 26, 2019 at 14:08

Bob Jarvis - Слава Україні

50.2k10 gold badges81 silver badges119 bronze badges

Collectives™ on Stack Overflow

Issues with Oracle SQL syntax error for DATE_SUB

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related