|
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.
TipEnsure 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. |