> ... %f option to strftime ... retu[r]ns '000' ... Is that always true, or just when the date is 'now'? I suspect that 'now' is producing an integer.
sqlite> select strftime('%f', 'now');
strftime('%f', 'now')
---------------------
52.000
sqlite> select strftime('%f', 'now');
strftime('%f', 'now')
---------------------
59.000
sqlite> select strftime('%f', '10:11:22.33');
strftime('%f', '10:11:22.33')
-----------------------------
22.329
Regards
