# HG changeset patch
# User Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
# Date 1709123821 -3600
# Node ID dc33533e6468b34a7fac9822b4352d0356fb4797
# Parent  f31366ece930bbc9d8b681a0cbafd11982f3ce8a
Target timezone is in minutes, setTimeZone is in seconds

diff --git a/src/main/java/org/monetdb/jdbc/MonetConnection.java b/src/main/java/org/monetdb/jdbc/MonetConnection.java
--- a/src/main/java/org/monetdb/jdbc/MonetConnection.java
+++ b/src/main/java/org/monetdb/jdbc/MonetConnection.java
@@ -234,7 +234,7 @@ public class MonetConnection
 				sendControlCommand("sizeheader 1");
 			}
 			if (!callback.timeZoneSet) {
-				setTimezone(target.getTimezone());
+				setTimezone(60 * target.getTimezone());
 			}
 		}
 
@@ -3754,7 +3754,7 @@ public class MonetConnection
 				defaultFetchSize = target.getReplySize();
 			if (contribute(SqlOption.SizeHeader, 1))
 				sizeHeaderEnabled = true;
-			if (contribute(SqlOption.TimeZone, target.getTimezone()))
+			if (contribute(SqlOption.TimeZone, 60 * target.getTimezone()))
 				timeZoneSet = true;
 		}
 
diff --git a/src/main/java/org/monetdb/mcl/net/Parameter.java b/src/main/java/org/monetdb/mcl/net/Parameter.java
--- a/src/main/java/org/monetdb/mcl/net/Parameter.java
+++ b/src/main/java/org/monetdb/mcl/net/Parameter.java
@@ -149,8 +149,8 @@ public enum Parameter {
 			case TIMEZONE:
 				Calendar cal = Calendar.getInstance();
 				int offsetMillis = cal.get(Calendar.ZONE_OFFSET) + cal.get(Calendar.DST_OFFSET);
-				int offsetSeconds = offsetMillis / 1000;
-				return offsetSeconds;
+				int offsetMinutes = offsetMillis / 60000;
+				return offsetMinutes;
 			default:
 				return defaultValue;
 		}