Specifies the timezone to apply to DATETIME types.

Data Type

string

Default Value

"SERVER"

Remarks

By default the add-in treats TIMESTAMP and DATETIME types the same. The ServerTimeZone property determines what the add-in does when it encounters either of these types. It can be set to the following values (see its documentation for how to reference specific timezones):

• LOCAL. This disables timezone conversions and returns the value as the server sent it.
• A specific timezone. This assumes all DATETIME and TIMESTAMP values are in that timezone.
• If not set, the add-in treats all DATETIME and TIMESTAMP values as being in the sesion timezone.

It is also possible to treat DATETIME and TIMESTAMP values differently. For example, you may want DATETIME to be a "wall clock time" that is not subject to timezones, while keeping the zoned behavior for TIMESTAMP. DateTimeTimeZone option lets you configure a separate behavior that applies only to the DATETIME type. It can be set to the following options:

• LOCAL. Like ServerTimeZone, this disables timezone conversions but only for DATETIME.
• A specific timezone. Like ServerTimeZone, this assumes all DATETIME values are in that timezone.
• SERVER. The default, this treats DATETIME values the same way as TIMESTAMP values. ServerTimeZone controls the behavior for both types.

Note: The add-in does not apply this value to DATETIME values set using prepared statement parameters. If you are using a platform timestamp type (such as java.sql.Timestamp or System.DateTime), the add-in always adjusts the timezone of the input value to match the ServerTimeZone option.