converting # of secs since 1970 to a date

From: Walker, Barry (EXCHANGE:CAR:5J42) <bwalker_at_americasm01.nt.com>
Date: 2000/06/16
Message-ID: <394A7E1E.3CA441F1@americasm01.nt.com>#1/1

I have a number stored in the database which represents the number of seconds since Jan 1 1970. i attempt co convert it to a date. Below are the query and results, the date/time is always 4 hours greater than it should be. Any ideas ??

select to_char(to_date('01-JAN-1970','DD-MON-YYYY')+( time_stamp / (60 * 60 * 24)) ,'DD-MON-YY HH24:MI'),provisionedcircuits from system.systemom where time_stamp='961178276';

TO_CHAR(TO_DATE PROVISIONEDCIRCUITS
--------------- -------------------

16-JUN-00 17:57                   6

--

Barry Walker

EMAIL: bwalker_at_nortelnetworks.com Received on Fri Jun 16 2000 - 00:00:00 CDT