I need a formula that converts the Remedy timestamp into Oracle date/time field. I have referred to KB article: 000000006132 and formula given in the article is working fine.
SELECT TO_CHAR(TO_DATE(’01/01/1970 00:00:00′, ‘MM/DD/YYYY HH24:MI:SS’) + (C3 / ( 60 * 60 * 24 )), ‘MM/DD/YY HH24:MI:SS’) FROM T40;
The returned date/time value is in GMT timezone.