HELP - utc date problem

From: <kal121_at_my-deja.com>
Date: Tue, 29 Aug 2000 23:49:56 GMT
Message-ID: <8ohi6s$jea$1@nnrp1.deja.com>

Here's the deal. I am receiving a date as a utc (universal time code) value from an application. The utc is the number of seconds elapsed since Jan. 1, 1970 at midnight. This number takes into account leap years.

How can I convert the utc back to a normal date, such as "29-aug-2000 02:30:35" accurately? It is not enough to simply divide the utc by 24/60/60 as this does not take into account leap years and it is wrong.

I don't see any oracle-provided date conversion packages for doing this.

Any suggestions?

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 29 2000 - 18:49:56 CDT