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: Time zones trying to synchronize application

Re: Time zones trying to synchronize application

From: Anil Bharadwa <anil_at_future-horizons.com>
Date: Wed, 10 Feb 1999 09:24:33 -0500
Message-ID: <36C196A1.76CD37F3@future-horizons.com>


Gerry we have been using this function however this does not give you the timezone of the server.
Thanks for trying though, Anil Bharadwa

Gerry Sinkiewicz wrote:

> Check out function new_time(date1,zone1,zone2)
> returns date in time zone2 when date1 is in time zone1.
>
> So if you seelct sysdate from dual and pass it to this function
> you can get GMT date-time.
>
> MStout2468 wrote:
> >
> > Anil,
> >
> > I don't know if there is a date format or function that gives GMT.
> >
>
> Text snipped because my ISP does not like more included than written text?
>
> --
> Gerry Sinkiewicz
> sinkiege_at_snet.net
Received on Wed Feb 10 1999 - 08:24:33 CST

Original text of this message

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