> On Feb 6, 2019, at 2:21 PM, J Decker <d3c...@gmail.com> wrote: > > From a JS point of view new Date( ISOString )and .toISOString() are quick > and available….
Available, yes, but expensive (compared to using a number.) > ISO format parsing is NOT that hard.... it's just a minor varient of > parsing floats. (maybe the conversion from parts into numeric?) Most date parsing (and formatting) functions are general-purpose and take format strings. That adds to the overhead. (SQLite does use a parser that’s specific to ISO-8661 and looks a lot faster.) —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users