SQLite Forum

Feature request: pragma for changing the precision / format of CURRENT_TIMESTAMP to YYYY-MM-SSTHH:MM:SS.SSS
Rounding should never be applied to computational intermediates but rather only the result.  

If the "first difference after the seconds" can be incorrect sometimes, that would also necessarily imply that the first digit of the millennium may be incorrect sometimes.

It is all a matter of perspective.