SQLite Forum

.param converts text to number - How to avoid this
Login
Hi,
When I define a param having integer it stores result value as below 

sqlite> .param set start_dt "2020-10-01"
sqlite> select  * from sqlite_parameters;
start_dt|2009



How to prevent this?  I want value to stored as string instead of result of numeric value