Jump to content

Finding last updated


coupe-r

Recommended Posts

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!!

Link to comment
https://forums.phpfreaks.com/topic/222109-finding-last-updated/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.