Hi Surya4u,
I used the following CASE statement with EST time and it has been working for
me since 2006.
CASE
WHEN c3 <= 0
THEN NULL
ELSE (NEW_TIME ( TO_DATE ('01/01/1970 00:00:00',
'MM/DD/YYYY HH24:MI:SS'
)
+ (c3 / (60 * 60 * 24)),
'GMT',
'EST'
)
)
END AS arrival_time
Hope this is helpful.
Regards,
Audrey Franklin
New York University
----- Original Message -----
From: surya4u <[email protected]>
Date: Monday, February 2, 2009 2:53 pm
Subject: Converting remedy timestamp into oracle date/time format
To: [email protected]
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
