Re: HELP - utc date problem

From: C. Ferguson <c_ferguson_at_rationalconcepts.com>
Date: Wed, 30 Aug 2000 00:32:49 GMT
Message-ID: <39AC566F.604D5954@rationalconcepts.com>

Hi,
You could write a java stored procedure to reinterrupt the utc (I'm assuming it's a long value) using the Date and Calendar classes of the Java API and then pop out an
Oracle Date type...

Or, rework the app to properly send a Date to the Database...

hth,
cindy

kal121_at_my-deja.com wrote:

> 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 - 19:32:49 CDT