将查询从MySql转换为Sqlite

将查询从MySql转换为Sqlite

这是基本语法：

select a.Date from (select date('now', '-'||(a.a + (10 * b.a) + (100 * c.a))|| ' days') as Date      from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) a cross join(select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) b cross join(select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) c    ) a;

我忽略了该

where

子句，因为这些日期是过去1000多个日期，因此他们无论如何都不会选择任何内容。