SQLite Forum

Problem using strftime with .parameter set in CLI
Login
When evaluating an expression for its **set** subcommand, .parameter is unwilling to recognize what you intended as an argument as the value argument when it embeds a space. Double-quote arguments with embedded space. For example:<code>
.parameter set @ts "strftime('%Y/%m/%d %H:%M:%f','now')"
</code>

(Added via edit:)
Gunter's statement of the problem is clearer, and closer to what the shell code does.  Its metacommand parser is relatively simple, not able to recognize expression syntax such as literal quoting, parenthesis, terms connected by binary operators, etc.  However, it does recognize stuff enclosed with a pair of doublequote characters as a single argument to be given in an argv array to the subcommands.