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 not working...
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;
I am in PST timezone and need formula that converts into oracle date/time
format....
--
View this message in context:
http://n2.nabble.com/Converting-remedy-timestamp-into-oracle-date-time-format-tp2259943p2259943.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
