> the workaround "strftime( '%Y-%m-%dT%H:%M:%fZ', 'now' )" is a bit clumsy And also very correct and the best way to do it. That's why those functions exist. Another option is making a UDF which you can have print the current time in any way you love. The obvious downside is that any SQLite connection wihtout your UDF added will not work, so you lose general SQL compatibility, but you have beautiful lean code. Now *that* is worthy of the "clumsy" moniker.