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!

Between dates sql

mist123Jul 1 2021

Hi All,

Oracle 11.2
I have a filter on the date column ...
AND (apsa.gl_date>='01-JAN-2020' or apsa.GL_DATE_CLOSED>='01-JAN-2020' and apsa.GL_DATE_CLOSED!='31-DEC-4712')
I need to fetch data only between '01-JAN-2020' and '31-MAY-2021'

Please help me.

This post has been answered by Frank Kulash on Jul 1 2021

Jump to Answer

Added on Jul 1 2021

6 comments

163 views

1 mention