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 timestamp_format property Next Page

UltraLite timestamp_increment property


Limits the resolution of timestamp values. As timestamps are inserted into the database, UltraLite truncates them to match this increment.

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 timestamp_increment=value

From Sybase Central    Use any wizard that creates a database.

On the New Database Options page, set the Timestamp Increment 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

1 to 60,000,000,000 microseconds

Default

1 microsecond

Remarks

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

This increment is useful when a DEFAULT TIMESTAMP column is being used as a primary key or row identifier.

See also
Example

To store a value such as '2000/12/05 10:50:53:700', set this property to 100000. This value will truncate the timestamp after the first decimal place in the seconds component.