Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use months_between as a filter

3127886Dec 1 2015 — edited Dec 1 2015

Hi,

I am curious why months_between doesn't work when used as a filter in a query.

Look at the following example which works correctly.

```

SELECT

DAY,

MONTHS_BETWEEN (SYSDATE,DAY) as diff

FROM TABLE

WHERE CHANNEL LIKE '%LCM%'

AND MONTH = '2015-09'

GROUP BY DAY

```

The following is not working.

```

SELECT

DAY

FROM TABLE

WHERE CHANNEL LIKE '%LCM%'

AND MONTHS_BETWEEN (SYSDATE,DAY) >=2

```

Do you know why?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2015
Added on Dec 1 2015
1 comment
656 views