/**/
DROP TABLE liberty.x;
CREATE TABLE liberty.x(d DATE, n VARCHAR(40));
DELETE FROM liberty.x;

INSERT INTO liberty.x VALUES( TO_DATE('2010/12/04:12:00:00AM', 'yyyy/mm/dd:hh:mi:ssam'), NULL);
INSERT INTO liberty.x VALUES( TO_DATE('2010/12/03:12:30:00AM', 'yyyy/mm/dd:hh:mi:ssam'), NULL);

COMMIT;

CREATE OR REPLACE TRIGGER liberty.xinsert
BEFORE INSERT
ON liberty.x
REFERENCING NEW AS NEW OLD AS Old
FOR EACH ROW
BEGIN

 --IF :old.IsAutoTriggered = 1 THEN
  :NEW.n   :=  '.' ||  TO_CHAR(:old.d, 'MM/DD/YYYY HH24:MM') || '.' || TO_CHAR( sys_extract_utc(current_timestamp) - :old.d, 'MM/DD/YYYY HH24:MM')  ||  '.';
     --END IF;
END;
/
COMMIT;

INSERT INTO liberty.x VALUES( TO_DATE('2010/12/03:04:30:00PM', 'yyyy/mm/dd:hh:mi:ssam'), NULL);
INSERT INTO liberty.x VALUES( TO_DATE('2010/11/02:12:30:00AM', 'yyyy/mm/dd:hh:mi:ssam'), NULL);
INSERT INTO liberty.x VALUES( TO_DATE('2009/12/02:12:30:00AM', 'yyyy/mm/dd:hh:mi:ssam'), NULL);
INSERT INTO liberty.x VALUES( TO_DATE('2010/12/04:01:30:00PM', 'yyyy/mm/dd:hh:mi:ssam'), NULL);
COMMIT;


SELECT
    TO_CHAR(liberty.x.d, 'MM/DD/YYYY HH24:MM') AS d_char,
    TO_CHAR(sys_extract_utc(current_timestamp) - liberty.x.d, 'MM/DD/YYYY HH24:MM') AS age,
    liberty.x.n
FROM liberty.x
ORDER BY liberty.x.d DESC;


/**/
/*
delete from liberty.x;
drop trigger liberty.xinsert;
drop table liberty.x;
*/