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( and time( to and in the outer query.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

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.