Re: Moving a Derby database across timezones

[Alan Burlison]

Daniel John Debrunner wrote:

It is the second, which is defined by the SQL standard which has 
datetime values with and without timezone. In SQL terms (section 4.6 of 
the SQL standard foundation document) Derby's TIMESTAMP is

  TIMESTAMP WITHOUT TIME ZONE

Yeah, I figured as much.  The spec gives you a choice of with/without 
timezone, and Derby implements the broken one.  How dumb.

--
Alan Burlison
--