I have EXPIRATION column in mysql table which contains date in following format
I am trying to query username whose expiry is on 2022-02-17 08:00:00 using below query
SELECT username FROM users WHERE expiration = DATE_ADD(curdate(), INTERVAL 1 DAY);
but getting no result. is something wrong with my query?