| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: Time zones trying to synchronize application
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
![]() |
![]() |