sqlite 在一个语句中按星期几过滤 [英] sqlite filter by day of the week in one statement

问题描述

我想在一个语句中按星期几(在我的示例中为星期四)进行过滤.下一条语句有效(请注意 date 是列名):

I would like to filter by day of the week (Thursday in my example) in one statement. The next statement works (please note that date is a column name):

SELECT CAST (strftime('%w', date) AS Integer) = 4 FROM sales WHERE id=123;

但是，当我包含上述过滤器时，我没有得到任何结果:

However, when I include the above filter I get no results:

SELECT * FROM sales WHERE id=123 AND (SELECT CAST (strftime('%w', date) AS Integer) = 4 FROM sales WHERE id=123) = 1;

推荐答案

虽然我不知道为什么以前的代码不起作用，但我发布了一个替代的工作解决方案:

Although I do not know why the previous code doesn't work I post an alternative working solution:

SELECT * FROM sales WHERE id=123 AND CAST (strftime('%w', date) AS Integer) = 4;

这篇关于sqlite 在一个语句中按星期几过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！