SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE transacts (id INTEGER PRIMARY KEY, time_UTC TEXT);
CREATE INDEX id_transacts_time ON transacts(strftime('%Y-%m', time_UTC));
EXPLAIN QUERY PLAN
SELECT DISTINCT strftime('%Y-%m', time_UTC) AS month 
FROM transacts 
ORDER BY month ASC;


id
parent
notused
detail


8
0
0
SCAN TABLE transacts USING INDEX id_transacts_time