Specifies the timezone identifier for the MySQL server, based on the current edition and platform. This setting controls how the driver interprets and converts datetime values between the server and client.

Data Type

string

Default Value

""

Remarks

Use this property to explicitly define the time zone of the MySQL server. This ensures correct handling of datetime fields, especially when the server and client are in different time zones.

The allowed inputs for this property are both edition-specific and platform-specific. Only Windows+.NET uses Windows timezone IDs, for example, "Pacific Standard Time" or "W. Europe Standard Time". Java and .NET on non-Windows machines use IANA timezone IDs, for example, "America/Los_Angeles" or "Asia/Shanghai".

Set this property to LOCAL, or leave blank, if the server and client are in the same timezone. In this case, no timezone conversion is applied.