Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find Timezone in Pl/SQL?

Re: How to find Timezone in Pl/SQL?

From: <happychappy_at_my-deja.com>
Date: 2000/03/22
Message-ID: <8ba285$9d8$1@nnrp1.deja.com>#1/1

In article <20000322011046.01936.00008123_at_ng-dc1.aol.com>, risudi_at_aol.com (Risudi) wrote:
> Would that give the Timezone of the machine the database is on, or the
 machine
> the java is running on.
>
> I mean...
> PC connects via WWW from California(PST) to a Web Server/Database
 server in New
> York(EST)
> What would be returned?
> Thanks
> rick
>

If you use embedded Java then it'll be running on the EST box and thus return the EST time, also upgrade from 815 to 816 815 is way too buggy.

PS you don't have to use Java you could use an call-out to any bit of 3GL, depends how portable you want it to be.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 22 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US