changeset 6:b4cf00b05ef1

Fix setting time zone for negative offsets. Port of changesets 5247c923260e and 084abef09d5d from MonetDB. This fixes bug 3985.
author Sjoerd Mullender <sjoerd@acm.org>
date Wed, 20 Apr 2016 10:15:54 +0200
parents ee47f0d6638a
children 3985e69b4ac3
files lib/MonetDBConnection.rb
diffstat 1 files changed, 8 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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'"