Question about timezone context within a trigger

From: jeffsumner <jeffsumner_at_sympatico.ca>
Date: 1 Dec 2005 08:22:21 -0800
Message-ID: <1133454141.706901.224450@g49g2000cwa.googlegroups.com>

Hi all!

I'm trying to write a trigger for an Oracle 9i database that keeps an audit trail of changes to a table. The users are in different timezones and access the database via a number of methods - none of which I have any control over.

The audit information I'm tracking includes the date and time when the user made a change - for consistency, I'd like this to be in UTC.

However, I've noticed that the timezone the trigger thinks it is in seems to be dependent on the incoming client. It also looks like some clients (JDBC clients, especially) don't always set the timezone properly.

My question is, is there any way to absolutely get the UTC timestamp (based on the *server's* timezone, which is always correct) from inside a trigger context?

Thanks in advance
Jeff Sumner Received on Thu Dec 01 2005 - 10:22:21 CST