How can I fetch data for future dates in MySQL

Question

I want to get the future game playing date. Field game_date is in format of d/m/Y and data type is varchar.

I am running this query. There are records available in the database but this query isn't fetching any data. Please help

Query

SELECT * FROM dx_scores
WHERE
    t_name='Team 11'
    and username='[email protected]'
    and STR_TO_DATE(game_date, '%d/%m/%Y' ) >= CURDATE();

make sure future data for given where condition is available in DATABASE — Dipesh Parmar
– Dipesh Parmar, Commented Apr 26, 2013 at 9:54

Praveen kalal · Accepted Answer · 2013-04-26 09:55:30Z

1

Please try this query

SELECT * FROM dx_scores WHERE t_name='Team 11' and username='[email protected]' and DATE(game_date, '%d/%m/%Y' ) >=  DATE(CURDATE());

answered Apr 26, 2013 at 9:55

Praveen kalal

2,0994 gold badges20 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1