Re: Epoch time to Oracle time...help needed

Hi Jim,

Oracle allows you to add a (integer or fraction) number of days to a date.
So, if X is your fixed point in time and S is your number of seconds,

X + S/86400

will give you the date represented by S in Oracle's DATE format.

Hope this helps,
Maurício.

-- 
Maurício Bellissimo Falleiros <mailto:mbf_at_uniconsult.com.br>

Uniconsult Sistemas e Serviços <mailto:uss_at_uniconsult.com.br>
R. Demóstenes, 627 cj.134/142 - Campo Belo - São Paulo/SP - 04614-013
Brasil
Fone/Fax: +55-11-5350885 +55-11-5333335

"Em um minuto apenas há tempo
Para decisões e revisões que um minuto revoga."
T.S.Eliot


* Sent from RemarQ http://www.remarq.com * The Internet's Discussion Network *
*  The fastest and easiest way to search and participate in Usenet - Free!   *