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 » Creating and Configuring UltraLite Databases » Choosing creation-time database properties for UltraLite

UltraLite time considerations Next Page

UltraLite timestamp considerations


UltraLite creates a timestamp from date and time parts that you set with the date_format and time_format properties. Together, date and time total seven parts (that is, year, month, day, hour, minute, second, and millisecond).

Timestamp values can, however, also be represented by strings. Before it can be retrieved, a timestamp value must be assigned to a string variable.

Typically timestamp columns ensure data integrity is maintained when synchronizing with a consolidated database. Time stamps help identify when concurrent data updates have occurred among multiple remote databases by tracking the last time that each user synchronized.

Tip

Ensure that the consolidated database and the UltraLite remote maintain timestamps and timestamp increments to the same resolution. By setting the these properties to match that of the consolidated database, you can help to avoid spurious inequalities.

See also