android编程大于等于,android-在SQLite中选择日期大于或等于今天的...

我的日期以dd / mm / yyyy格式存储在数据库中,并且我只想显示日期等于或大于今天的项目.

我尝试了WHERE date(fixtures.date)> = date(‘now’),但没有任何结果.

下面是我的查询,任何帮助将不胜感激

SELECT fixtures.id,

fixtures.team_1_id,

fixtures.team_2_id,

fixtures.date,

fixtures.time,

fixtures.pitch,

teams.team_name,

teams_1.team_name AS awayTeam,

leagues.league_name

FROM fixtures

INNER JOIN teams

ON fixtures.team_1_id = teams.id

INNER JOIN teams AS teams_1

ON fixtures.team_2_id = teams_1.id

INNER JOIN teams_vs_leagues

ON teams.id = teams_vs_leagues.team_id

INNER JOIN leagues

ON teams_vs_leagues.league_id = leagues.id

WHERE date(fixtures.date) >= date('now')

ORDER BY fixtures.date DESC