SQLite Forum

Command Line Shell set parameter as date
Login
Windows 10 Sqlite 3.35.3 2021-03-26

This is probably an artifact of my ignorance but how can you set a parameter's value to a date string (e.g. '2021-03-01') without having it converted to a number (e.g. '2017')

~~~
  sqlite> .param init
  sqlite> .param set :date 2021-03-01
  sqlite> .param list
  :date 2017
  sqlite> .param set :date "2021-03-01"
  sqlite> .param list
  :date 2017
  sqlite> .param set :date '2021-03-01'
  sqlite> .param list
  :date 2017
~~~

Thanks.