sqlite SQL Date Query Question

I want to select a date range in sqlite, but it doesn't work normally.

SELECT * FROM test WHERE date BETWEEN "11/1/2011" AND "11/8/2011";

How do I send a query?

sqlite sql

2022-09-22 21:24

1 Answers

In sqlite, date format should be as follows.

YYYY-MM-DD
YYYY-MM-DD HH:MM
YYYY-MM-DD HH:MM:SS
YYYY-MM-DD HH:MM:SS.SSS
YYYY-MM-DDTHH:MM
YYYY-MM-DDTHH:MM:SS
YYYY-MM-DDTHH:MM:SS.SSS
HH:MM
HH:MM:SS
HH:MM:SS.SSS
now
DDDDDDDDDD

Try changing the query as below

SELECT * FROM test WHERE date BETWEEN "2011-01-11" AND "2011-8-11"

For more information, see SQLite site.

2022-09-22 21:24

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656