Hi, I have a table in a database that looks like this: CREATE TABLE Data(RowID CHAR(16) FOR BIT DATA PRIMARY KEY,Value LONG VARCHAR NOT NULL,LastUpdated TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP)
As you can see, the LastUpdated field defaults to CURRENT TIMESTAMP. However, this value is always my local timezone (GMT+12). How can I automatically convert it to GMT using a builtin database function? I am working in GMT timestamps because it is not possible to use the timezone of the server for the timestamps because there is no server (a separate copy of the database is stored in several nodes all over the world, and it replicates the data based on timestamp (which is why the timestamp must be in GMT for it to be accurate)). I want to avoid doing this at the application level because I have a lot of code that omits the LastUpdated field when creating a new record, so I would like to set it automatically. Can someone help me? Thanks, Erin
