mysql date of min, max

[bill-lancaster]

I have a mysql table of temperature readings.
How can I find the date of MAX(Temperature) and the date of MIN(Temperature)?
My table looks like this:-
EpochDate as String
ReadingDate as Date
Temperature as Float
Pressure as Float

[thatbruce]

SELECT
"EpochDate",
'max' as ind
FROM yourtable
WHERE temperature = (Select Min("Temperature") from yourtable)
UNION
SELECT
"EpochDate",
'min' as ind
FROM youtable
WHERE temperature = (Select Max("Temperature") from yourtable);

(or whatever the equivalent SQL is in that g-awful rdbms is).
You should get the jist anyway.

[bill-lancaster]

Thanks for that, struggling to translate your query to mysql syntax.
However, there would be a problem because there could easily be several maximum temperatures with completely different dates.
I need to re-think this.
Thanks again