SQLite time period Query

The same SQL statement, the data can not be found to

SELECT * FROM table1 where t1>= ' 2017-6-1 ' and t1<= ' 2017-6-5 '

Change into

SELECT * FROM table1 where t1>= ' 2017-06-01 ' and t1<= ' 2017-06-05 '

So that we can find out the data to

The T1 in the database can be set to the text DATE datetime.

If it is only the date please set it to date,

If a datetime is set to date time,

Of course, the text is OK, only the value can be entered.

//--------------------------------------------------------------------------------------------------------

Here are the following from the SQLite expert personal:

SQLite time period Query