SQL parameters: sqltz

Startup parameters change the behavior of the Service Manager server. You can always set a startup parameter from the server's operating system command prompt.

Parameter

sqltz

Description

This is an optional parameter that the Service Manager server uses to control storing of date and time values in the RDBMS. This parameter defines the time zone to use as a base for all date and time values. The time zone is specified as the name of the time zone record in the Service Manager tzfile. The default time zone is Greenwich/Universal (GMT).

Valid if set from

Server's operating system command prompt

Initialization file (sm.ini)

Requires restart of the Service Manager server?

Yes

Default value

Greenwich/Universal (GMT)

Possible values

Time zone name as defined in Service Manager time zone record (tzfile)

Example usage

Command line: sm -httpPort:13080 -sqldb:dbserver -sqltz:Canada/Atlantic

Initialization file: sqltz:Canada/Atlantic

Related topics

System parameters

Related topics

Enter a parameter in the sm.ini file

Related topics

Database parameters