Rephrase: GMT Time for an Oracle Stored Procedure

From: Gaurav Swarup <gswaroop_at_slb.com>
Date: Thu, 7 Jun 2001 16:33:06 +0100
Message-ID: <9fo71v$r5p$1@news.sinet.slb.com>

Currently my oracle machine is in Rio Brazil and follows the local time. In my PL/SQL procedures I need to put date stamp in columns with the GMT.

I have taken a look at NEW_TIME function in 8i documentation, but it seems to support only a few (US ones I guess) time zones. It doesn't allow any other time zone. Nor does it seem to work in sync with the OS time zone settings...

Any ideas?

"Gaurav Swarup" <gswaroop_at_slb.com> wrote in message news:9fo330$mgv$1_at_news.sinet.slb.com...
> I need to stamp every inserts in a table by the GMT time stamp. Can anyone
> tell me how to get the GMT time. I could see that SYSDATE gives me the
> local time, but I could not find any info on how to get the GMT time
>
> Thanks
>
>
>
Received on Thu Jun 07 2001 - 10:33:06 CDT