Re: GMT Time for an Oracle Stored Procedure

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 07 Jun 2001 16:44:01 -0700
Message-ID: <3B2011C1.9F44DE33@exesolutions.com>

Gaurav Swarup wrote:

> 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

Is the offset from your server to GMT a constant? If it isn't you may need to write a very ugly proc or use a Java library that already contains this functionality.

If it is a constant I would just write a simple function.

Daniel A. Morgan Received on Thu Jun 07 2001 - 18:44:01 CDT