UltraLite time_format creation parameter

Sets the format for times retrieved from the database.

For Android smartphones, you can use Connection.setOption(OPTION_TIME_FORMAT, value) as an alternative to setting this creation parameter. See Connection.setOption method [UltraLiteJ] and Connection.OPTION_TIME_FORMAT variable [BlackBerry] [UltraLiteJ].

Syntax

 ulinit  --time_format=value

Remarks

UltraLite writes times from time parts you set with the time_format creation parameter. Time parts can include hours, minutes, seconds, and milliseconds.

Time values can also be represented by strings. Before a time value can be retrieved, it must be assigned to a string variable.

ISO (HH:MM:SS) is the default time format. For example, "midnight" in this international format is written: 00:00:00. If you do not want to use the default ISO time format, you must specify a different format and order for these time parts.

The format is a string using the following symbols:

Symbol	Description
HH	Two digit hours (24 hour clock).
NN	Two digit minutes.
MM	Two digit minutes if following a colon (as in hh:mm).
SS[.s...]	Two digit seconds plus optional fraction.

You cannot change the time format of an existing database. Instead, you must create a new database.

Each symbol is substituted with the appropriate data for the time that is being formatted. Any format symbol that represents character rather than digit output can be put in uppercase, which causes the substituted characters to be in uppercase. For numbers, using mixed case in the format string suppresses leading zeros.

You can control zero-padding with the case of the symbols:

Type the symbol in same-case (such as HH or hh) to allow zero padding. For example, HH:NN:SS could produce 01:01:01.
Type the symbol in mixed case (such as Hh or hH) to suppress zero padding. For example, Hh:Nn:Ss could produce 1:1:1.

From Sybase Central, you can set the time format in any wizard that creates a database. On the New database creation parameters page, click the Time Format option.

From a client application, set this parameter as one of the creation parameters for the create database method on the database manager class.

Example

Discuss this page in DocCommentXchange.