Got a sticky problem which is causing me a few problems in Query Builder Oracle...... HELP PLEASE!!!!!
I have a date and I want to know how many days have passed.
I have used the help facility and so far have come up with:
MONTHS_BETWEEN(SEV_ACTUAL_DATE, SYSDATE)
This returns the months between.
Is there such a command as days_between or similar?
Thanks
JB
I have a date and I want to know how many days have passed.
I have used the help facility and so far have come up with:
MONTHS_BETWEEN(SEV_ACTUAL_DATE, SYSDATE)
This returns the months between.
Is there such a command as days_between or similar?
Thanks
JB