SQLite Forum

Command Line Shell set parameter as date
That's an excellent question. I suspect the value's type affinity was intended to actually be "any".  It works better that way (as Keith says.)

It would be helpful if you and/or others would make the best argument for retaining the current behavior for the sake of backward compatibility. I am inclined to think that where anybody has somehow come to rely on the current behavior, it is only by accident or extremely contrived usage, and that avoiding anomalies such as your "Uh-oh" will, overall, produce fewer problems for shell users. (It helps that .parameter is a relatively recent addition.)