Getting max temp values

[Patrick Simonds]

A total neophyte to MySQL, but I have created a weather database and I want to be able to pull out the max temp for each day and the last time on that day it occurred. I have created my view and it returns the max temp for each day but does not give me the correct EventTime, mostly returning 00:00:00. Currently the view returns just over 5300 rows in just under 5 seconds.

Any help would be appreciated.


CREATE
ALGORITHM = UNDEFINED
DEFINER = `root`@`localhost`
SQL SECURITY DEFINER
VIEW `view_testtest` AS
SELECT
`weatherhistorical`.`EventDate` AS `EventDate`,
`weatherhistorical`.`EventTime` AS `EventTime`,
MAX(`weatherhistorical`.`TempOut`) AS `TempOut`
FROM
`weatherhistorical`
GROUP BY `weatherhistorical`.`EventDate`