ulinit  --time_format=value

String (composed of the symbols listed below)

HH:NN:SS.sss

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:

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:

From Sybase Central, you can set the time format in any wizard that creates a database. On the New database creation parameters page, select 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.

• UltraLite timestamp_format creation parameter
• UltraLite Initialize Database utility (ulinit)
• UltraLite Load XML to Database utility (ulload)
• UltraLite for embedded SQL: ULCreateDatabase method
• UltraLite for C++: CreateDatabase method
• UltraLite.NET: CreateDatabase method
• UltraLite for M-Business Anywhere: createDatabase method
• Accessing creation parameter values

If a transaction was executed at 3:30 P.M. and you used the default time_format syntax of HH:NN:SS.sss, the result would be:

15:30:55.0