Skip to Main Content

APEX

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 calculate in a query the number of days between two dates and place the result in a column

Hello, in a table on an Oracle Apex page I have 3 columns:
"license start date", license end date" and "number of days". In "number of days", I want to write an SQL query that calculates the number of days between the license dates of the other two columns and enters the result. Could you please help me, I have tried with DateDiff(day), with Months_between, and with what I have found in notes and it tells me that it does not recognize them.

Comments
Post Details
Added on Jan 5 2024
5 comments
484 views