On 08-08-2007 07:02:32 -0700, Colin Foss wrote:

The problem with that approach is it is a fixed offset. It doesn't account for DST shifts.

Ok, but if you script that, it can be accounted for, unless you have clients going over the DST shift, which means you should re-set them if that happens.

--- Fabian Groffen wrote:

...

On 07-08-2007 12:44:43 -0700, Colin Foss wrote:

...

How can I configure the local time zone for MonetDB?

Upon login, "select current_timezone" returns 0.

set time zone local always resets the offset to 0.

...

Can I change this to follow my server's GMT offset including DST?

Like JDBC does upon connecting:

SET TIME ZONE INTERVAL 'XX' HOUR TO MINUTE;

where is something like '+01:00'

-------------------------------------------------------------------------

...

This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/monetdb-users

...

------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users