db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: how to set the timezone of CURRENT_TIMESTAMP to GMT?
Date Tue, 09 Feb 2010 02:33:30 GMT
"Bernt M. Johnsen" <Bernt.Johnsen@Sun.COM> writes:

> Den 02/08/2010 10:40 AM, skrev Erin Drummond:
>> 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 a work-around you could auto-record the time zone using a generated
column and a function which looks up the time zone.

Dag

Mime
View raw message