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:

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.

Default

HH:NN:SS.SSS

Remarks

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
Example

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:

15:30:55.0