The problem with that approach is it is a fixed offset. It doesn't account for DST shifts.
--- Fabian Groffen <[EMAIL PROTECTED]> 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