The "time" column should probably be using the MySQL "DATETIME" type instead of "VARCHAR(255)" type (storing the date as a string) to improve database queries.
Workaround: cast the "time" column to to date in queries like:
SELECT * FROM sometable
WHERE DATE(STR_TO_DATE(time, '%Y-%m-%dT%H:%i:%s')) = CURDATE();
The "time" column should probably be using the MySQL "DATETIME" type instead of "VARCHAR(255)" type (storing the date as a string) to improve database queries.
Workaround: cast the "time" column to to date in queries like: