Re: Time zones trying to synchronize application

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 Tue Feb 09 1999 - 17:08:01 CST