Timestamps in the recovery database are stored as both seconds and microseconds. The closest I can come in Tcl is millisecond precision (3 decimal places) using ‘clock clicks -milliseconds’. Accuracy is poor — as documented, Tcl’s milliseconds don’t correspond to the system clock. (When the second changes on the system clock, the millisecond value doesn’t end with anything close to 000.)
Does anyone know how to synchronize precise times (I’d be happy with milliseconds) to the system clock so we can use timestamps with fractional seconds?
- Mark Thompson
HealthPartners