Re: converting # of secs since 1970 to a date

Could the time difference be the result of different time zones? If the time is stored based on GMT and you are looking at EDT, there would be a four hour time difference.

HTH
    James

In article <394A7E1E.3CA441F1_at_americasm01.nt.com>,   "Walker, Barry (EXCHANGE:CAR:5J42)" <bwalker_at_americasm01.nt.com> wrote:
> 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

>

>


--
Life is complex; it has real and imaginary parts.


Sent via Deja.com http://www.deja.com/
Before you buy.