SQLite Forum

Feature request: pragma for changing the precision / format of CURRENT_TIMESTAMP to YYYY-MM-SSTHH:MM:SS.SSS
I suppose it would be necessary to find a "binary point", similar to the "decimal point in effect.

My opinion about "whole seconds" is not because they are "whole". It is because there is not much more accuracy to be routinely had; the error is such that, even with <u>[NTP](https://en.wikipedia.org/wiki/Network_Time_Protocol)</u> in use, the first digit after the (seconds) decimal can be wrong sometimes.