Thursday, December 13, 2007

How to deal with timezones in hsqldb - no gap filled yet?

Working with timeseries of environmental data, there is a big need to have the daylight saving switched OFF, else the unique dates will appear more than once :)

For now, with hsqldb and java there is only one way I found to deal with that, i.e. setting another timezone.

In the Italian Job case, Africa answers the call for help:
-Duser.timezone="Africa/Kinshasa"
saves us by giving the same zone, but without the daylight saving.

Thank God there is Kinshasa! ;)

No comments: