|
Limits the resolution of timestamp values. As timestamps are inserted into the database, UltraLite truncates them to match this increment.
UltraLite employs different methods for setting this property:
| Context | Implemented 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. |
1 to 60,000,000,000 microseconds
1 microsecond
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.
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.