====
SQL>SELECT TO_TIMESTAMP_TZ('01/01/1970 00:00:00 EST', 'mm/dd/yyyy HH24:MI:SS TZD')
+ ((1112390687 / 86400) - (18000/86400))
FROM dual;
TO_TIMESTAMP_TZ('01/
--------------------
Apr 01 2005 16:24:47
========

What is the result you expect here?

You are adding a number after a date is formatted with TO_TIMESTAMP_TZ function.

Very few people use TO_TIMESTAMP_TZ format in real system. That is why you do not answer.

Hmm, Is TO_TIMESTAMP_TZ for OCP only ?

Tamil