In Oracle APEX, you can format dates using predefined method of report columns. We are getting following different predefined formats:
Here, I just want to show you how SINCE & SINCE_SHORT formats the dates to descriptive and meaningful way. Below is a sample report data.
Similarly, if you want to format your dates in PL/SQL or in CUSTOM regions, you can use APEX_UTIL.GET_SINCE