SQLite Forum

Feature request: pragma for changing the precision / format of CURRENT_TIMESTAMP to YYYY-MM-SSTHH:MM:SS.SSS
Login
Hello Ryan,
you got me wrong. Let me clarify my argumentation.

Not the function **strftime itself** is clumsy, but the **SQL interface** is

when the user has to use it instead of **CURRENT_TIMESTAMP**.

That's why CURRENT_TIMESTAMP exists

and it should give you a timestamp with maximum possible precision.

This is how it works in all major sql database systems.

best regards