skip to main content
Connection Properties Reference : Client Time Zone
 

Try DataDirect Cloud Now

Client Time Zone

Attribute

ClientTimeZone (CTZ)

Purpose

Specifies the time zone other than UTC (Universal Time Coordinated) that should be used when translating data store time and timestamp values between the DataDirect Cloud service and the driver. Most data stores use UTC while applications use and supply time and timestamp values in local time for the client. If the ClientTimeZone value is not specified (the initial default value), the driver uses system-specific client time zone settings to convert between the UTC time used by the cloud service and the local time used by the client application. The driver returns an error at connect time if it cannot obtain the client time zone. Client time zone settings vary among operating systems:
*On Windows systems, the driver translates the system time zone to an equivalent client time zone.
*On UNIX and Linux systems, the client time zone is set using the TZ variable, with the following exceptions:
*On Linux systems, if TZ is NULL or empty, the client time zone comes from the ZONE value in the following file: /etc/sysconfig/clock
*On Solaris, TZ may contain localtime. In this case, the driver uses the /etc/localtime link to determine the client time zone.
If you want the cloud service to verify that this time zone has certain characteristics, you can append some verification information onto the time zone, an offset and daylight saving time indicator. The offset specification is the number of hours (and optional minutes) behind (indicated by a leading minus sign) or ahead (indicated by no sign or a plus sign) of UTC. If the time zone is expected to support daylight saving time, append D to the offset.

Valid Values

timezone[,[+ | -]HH[:MM][D] 
where:
timezone
is a valid Java TimeZone ID. See your Java documentation or use the TimeZone.getAvailableIDs() method to return a list of valid IDs.
+ | -
optionally specifies whether the offset is before or after Greenwich Mean Time.
HH:MM
optionally specify the number of hours and minutes to offset the time from Greenwich Mean Time.
D
signifies whether the time zone adjusts for daylight savings time.

Example

America/New_York 
America/New_York,-5D 
America/New_York,-05:00D 
Asia/Calcutta,5:30 
Asia/Calcutta,+5:30 

Default

Empty (the driver determines the client time zone based on the system-specific time zone settings)

GUI Tab

Advanced tab