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!

timestamp column formatting in interactive report

mediapNov 4 2021

Hi,
I've an interactive report with timestamp column.
the source of this report is a sql query and it includes a timestamp column.
The report does not display the whole timestamp like DD-MON-YYYY HH24:Mi:SS.
I've tried to change the "Appearance" attribute of the column to DD-MON-YYYY HH24:MI:SS
but no success.
I've also tried to select the column with to_char(event_timestamp,'DD-MON-YYYY HH24:MI:SS')
no success.
image.png
how can I change this ?
thanks in advance for your answers
regards
Chris

This post has been answered by Pierre Yotti on Nov 6 2021
Jump to Answer
Comments
Post Details
Added on Nov 4 2021
10 comments
929 views