Query to find the most recent date

[only1perky]

Hi Guys,

 

I have a mysql table that stores date and time in a field in the format '19-08-09 11:56', I need to use a query to get the date that is closest to the current date, how would I do so?

 

I've tried using SELECT MAX(datetime) but for some reason this is not pulling the most recent field.

 

Any help would be appreciated.

 

Thanks.

[Maq]

MAX() should work on a datetime field. 

Is your column really called 'datetime'?

It would be nice if you showed us the entire query.

 

This will work as well:

 

SELECT `datetime` FROM table ORDER BY `datetime` DESC