From: Frederik E. <fre...@a5...> - 2006-08-10 15:19:31
|
In HSQL, why are 'datetime' columns interpreted as being in the local timezone? I would think that UTC would be more useful. If the local timezone is used, then it makes it more difficult to move a server between timezones, or to have multiple servers in multiple timezones. Frederik On Sat, Aug 05, 2006 at 06:59:21PM +0100, Frederik Eaton wrote: > Thanks! >=20 > On Sat, Aug 05, 2006 at 05:27:04PM +0200, Bjorn Bringert wrote: > > On Aug 5, 2006, at 3:34 PM, Frederik Eaton wrote: > >=20 > > >On Sat, Aug 05, 2006 at 11:15:19AM +0200, Bjorn Bringert wrote: > > >>On Jul 31, 2006, at 12:55 PM, Frederik Eaton wrote: > > >> > > >>>Hi, > > >>> > > >>>I'm attaching another HSQL patch. > > >>> > > >>>It allows users to specify a port number with the server name in t= he > > >>>MySQL client. > > >>> > > >>>Frederik > > >> > > >>Hi Frederik, > > >> > > >>the patch doesn't apply cleanly against the current CVS version. Is > > >>there any chance you could make a patch against the CVS version > > >>instead? > > > > > >It's a very simple modification, can't you just copy and paste from > > >the patch? > >=20 > > It appears to have been a simple whitespace mismatch problem (tabs in= the original HSQL source). I=20 > > have committed your patch to CVS. > >=20 > > Thanks! > >=20 > > /Bj=F6rn > >=20 > >=20 > >=20 >=20 > --=20 > http://ofb.net/~frederik/ >=20 --=20 http://ofb.net/~frederik/ |