That formula will give you the time in GMT.
To convert it to PST you will need to account for the hours offset (see below).
I believe the offset for you is 8 hours (Greenich Mean Time is 8 hours ahead
of you so you need to subtract). Im in EST and I believe I have to offset it
by 5 hours. I put the "8" in the formula below with {} around it. I am not
sure if that is the right offset for you from GMT.
SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYY HH24:MI:SS') +
(C3 / ( 60 * 60 * 24 ) - ( 60 * 60 * {8} ),
'MM/DD/YY HH24:MI:SS')
FROM T40;
Thanks
Peter Lammey
ESPN IT Client Architecture and Automation
860-766-4761
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of surya4u
Sent: Monday, February 02, 2009 2:53 PM
To: arslist@ARSLIST.ORG
Subject: Converting remedy timestamp into oracle date/time format
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"
Please consider the environment before printing this e-mail.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
