Limits the resolution of timestamp values. As timestamps are inserted into the database, UltraLite truncates them to match this increment.
{ ulcreate | ulinit | ulload } -o timestamp_increment=value;...
1 to 60000000 microseconds
1 microsecond
1000000 microseconds equals 1 second.
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.
From Sybase Central, you can set the timestamp increment in any wizard that creates a database. On the New database creation parameters page, select the Timestamp Increment option.
From a client application, set this parameter as one of the creation parameters for the create database method on the database manager class.
To store a value such as '2000/12/05 10:50:53:700', set this creation parameter to 100000. This value truncates the timestamp after the first decimal place in the seconds component.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |