On Tue, Apr 17, 2012 at 2:45 PM, Richard Hipp <d...@sqlite.org> wrote: > On Tue, Apr 17, 2012 at 2:44 PM, Nico Williams <n...@cryptonector.com>wrote: >> Note that you'll lose any fractional second information when you do >> this. On the other hand, fractional second information does not sort >> properly when compared as text, > > Huh? The standard format is YYYY-MM-DD HH:MM:SS.SSS. I think that sorts > in time order when compared as strings. Do you have a counter-example?
I could swear that I observed %f produce variable numbers of digits for the decimal part. But now I don't see that. An Emily Litella moment for me. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users