Re: HELP - utc date problem

We have the same issue. Incoming UTC dates are implicitly stored under the database's timezone when run through the to_date function. To solve the problem we wrote a simple Java stored procedure to return the database timezone, providing one of the parameters to new_time.... you know the other parameters (GMT and your date string). Support told us that 8.1.7 will include built-in functions to do this. You may want to grep the catalog scripts in 8.1.6 for the package headers containing UTC/GMT.

kal121_at_my-deja.com wrote in message <8ohi6s$jea$1_at_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 - 22:08:47 CDT