# HG changeset patch
# User Sjoerd Mullender <sjoerd@acm.org>
# Date 1461140154 -7200
# Node ID b4cf00b05ef11b5bf454dd5314611a57bdca6461
# Parent  ee47f0d6638a404851e55e92225a377bd8e53033
Fix setting time zone for negative offsets.

Port of changesets 5247c923260e and 084abef09d5d from MonetDB.
This fixes bug 3985.

diff --git a/lib/MonetDBConnection.rb b/lib/MonetDBConnection.rb
--- a/lib/MonetDBConnection.rb
+++ b/lib/MonetDBConnection.rb
@@ -398,8 +398,14 @@ class MonetDBConnection
   def set_timezone()
     tz = Time.new
     tz_offset = tz.gmt_offset / @@HOUR
-      
-    if tz_offset <= 9 # verify minute count!
+
+    # verify minute count!
+    if tz_offset <= -10
+      tz_offset = "'" + tz_offset.to_s + ":00'"
+    elsif tz_offset < 0
+      tz_offset = -tz_offset
+      tz_offset = "'-0" + tz_offset.to_s + ":00'"
+    elsif tz_offset <= 9
       tz_offset = "'+0" + tz_offset.to_s + ":00'"
     else
       tz_offset = "'+" + tz_offset.to_s + ":00'"