Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Database Settings Reference » Configurable properties in UltraLite

UltraLite scale property Next Page

UltraLite time_format property

Sets the format for times retrieved from the database.

How to set it

UltraLite employs different methods for setting this property:

ContextImplemented by

From the command line    Use any utility that creates a database.

Use the following property syntax:

-o time_format=value

From Sybase Central    Use any wizard that creates a database.

On the New Database Options page, set the Time Format option.

From a client application    Use the create database method.

Set this property as one of the creation parameters for an API's create database method on the database manager class.

Allowed values

A string using any of the following symbols:




Two digit hours (24 hour clock).


Two digit minutes.


Two digit minutes if following a colon (as in hh:mm).


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.

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

See also

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