Skip to Main Content
Forums

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!

Compute the difference between sysdate and an interactive report date

Barry BSep 7 2021

Hi,

We are on Apex 18.
We have a report which shows a date field.
select changed_time from...
The field is a TIMESTAMP(6)
It is display as a plain text field with a format mask:
DD-Mon-YY HH24:MI.SS
image.pngOur user would like to use a compute interactive function to derive the difference between timestamp and that date.
image.pngIt returns the strangely formated number shown.
In SQL I would use an "extract" function to display the hours, minutes, seconds.
Any ideas?
This post has been answered by fac586 on Sep 8 2021
Jump to Answer
Comments
Post Details
Added on Sep 7 2021
#apex, #apex-discussions
11 comments
523 views