Display date columns in hours and minutes format

Columns of type DATE automatically show in full date format.
​
In order to display Insight columns that default to displaying dates rather than hours and minutes, use the TO_CHAR conversion to change the date format.
​
to_char([INSIGHT_ITEM}, 'HH24:MI')
​
For example, to display DEFAULT_START_TIME on the Work Pattern view as 08:00 rather than 12-AUG-2022, use the following:
​
to_char(CTCI_WORK_PATTERN.DEFAULT_START_TIME, 'HH24:MI')