-
Committer:
Vladislav Vaintroub
-
Date:
2013-09-20 12:07:24 UTC
-
Revision ID:
wlad@montyprogram.com-20130920120724-bi1hs624myqq4lo2
CONJ-65 : add new connection parameter serverTimezone, compatible to Connector/J
If set, timezone conversions will occur when storing temporal data with preparedStatement (setDate(), setTime(), setTimestamp())
and when reading data using ResultSet (getDate(),getTime(),getTimestamp())
The effect is similar to setting time_zone session variable. The difference is better cross-platform compatibility (i.e timezone names like "Asia/Omsk" can be used also when server is on Windows). Also, this optzion works for both datetime and timestamp datatypes, while server-side option has no effect on datetime.