This content has been marked as final. Show 2 replies
I think you need to extract the JULIAN_DAY_NUMBER. It will be something like
FLOOR((EXTRACT(SYSDATE, JULIAN_DAY_NUMBER) - EXTRACT(date1, JULIAN_DAY_NUMBER))/30) + 1
You can change the subtraction order, use ABS, use CEIL instead of FLOOR, or adjust boundries according to your needs.
For EQL syntax documentation see "Endeca Server Query Language Reference" under http://docs.oracle.com/cd/E35822_01/index.htm
Thanks a lot!!! Worked just as I needed it. Will go through the documentation.