Dear All, I have a problem selecting the maximum (ie most recent) date from a MySQL Database. I have used the following SELECT;
SELECT Field1, Field2, Field3, Field4, DATE_FORMAT(MAX(Field5), '%Y %m %d %h %i %s') AS Field5 FROM table GROUP BY Field1
It doesn't produce an error, but it doesn't pick the most recent date either. The result doesn't change if I change MAX to MIN either.
Any ideas?
Cheers!
SELECT Field1, Field2, Field3, Field4, DATE_FORMAT(MAX(Field5), '%Y %m %d %h %i %s') AS Field5 FROM table GROUP BY Field1
It doesn't produce an error, but it doesn't pick the most recent date either. The result doesn't change if I change MAX to MIN either.
Any ideas?
Cheers!