Finding last updated

[coupe-r]

Hi All,

 

I'm trying to get the last updated record while my updated_on column is in DATETIME format (Y-m-d H:i:s).

 

I have:

 

SELECT * FROM properties WHERE updated_on < date(now())

 

but know this isn't right.

 

Also, if multiple records are updated on the same day, I would like it to look at the times and pick the latest time.

 

Any help would be greatly appreciated.

 

Thank you for reading!!

[smerny]

I would like it to look at the times and pick the latest time.

 

are you just looking for this?

 

SELECT * FROM properties ORDER BY updated_on DESC LIMIT 1

[coupe-r]

WOW, I thought I had to get the date functions involved.  Soo simply and it didn't even cross my mind.

 

Thank you very much