MySQL Forums
Forum List  »  Newbie

Re: Finding min é max values for each day
Posted by: Peter Brawley
Date: November 30, 2017 12:44PM

> "I would like to get the datetime for min and max temperatures for each day"

The date of the min or max time for a given date is, um, that date.

If you wish the query to repeat that information, simply change time(mins.date) and time(maxs.date) to mins.date and maxs.date in the outer query.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.