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 <[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 ------------------------------------------------------------------------- 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
