SQLite Forum

Feature request: pragma for changing the precision / format of CURRENT_TIMESTAMP to YYYY-MM-SSTHH:MM:SS.SSS
Accuracy and precision have different but precise meanings where scientific measurement is concerned. Accuracy should be specified by  its +/- limits, such as 3.3 +/- 0.1, that is, with an error figure.

Precision indicates how many significant figures (digits) a value is specified to. So, two in the above example. If the error is in the second digit, there is not much point in specifying greater precision. Thus, 3.31234 +/- 0.111 adds no utility and no extra information to the result.

Personally if I'm doing timing measurements, I'd ask the OS directly rather than expect SQLite to help.