Get the time when was the Record was inserted

December 16, 2016Posted inAPEX, ORACLE, SQL

To show the posted time or when the data is inserted into the table. The idea of showing the date in this format came from the social site post time display schemes eg. Facebook, Google Plus, Linked In etc for tracking the time we generally use the date column with the default value of the SYSDATE. but it just shows the time when it was inserted into the table.

If we want to display how much time before the record was posted or inserted we can use the apex_util.get_since function. It will give you the round value in 19 hours ago format. It looks user-friendly and understandable.

Copy Code
select apex_util.get_since(created_on) from table;

Output: 

Reports

  • Go to Report Date Column
  • In Column Attributes, move to appearance
  • Under Format Mask, Add SINCE
  • Save and Run
Tags: