simple date question

[da_marek]

how to display time when last time database was updated?

[Stinger51]

If you are using MySQL, there is a time stamp type that gets updated anytime you change something in that record field. But I don't know of anything that applies to the entire database.

Why would you want to know this anyway, rather than what time a record was updated?

If you need to know what time the entire DB was updated, then you are going to have to track each and every record with time stamps and query for the lastest one.

[da_marek]

well... you're right! i need the date of record field update, not entire database... sorry! but whats the code anyway?

[Stinger51]

For starters, check out this info in the MySQL on-line manual :

http://www.mysql.com/doc/en/DATETIME.html

You may decide to use a datestamp instead, and update the time manually. It depends upon what you are trying to do. And that depends upon your DB table. So I can't give you any code, just maybe some pseudcode or ideas.

What type of record are you trying to update, e.g. what are its fields? When does this update happen, who or what initiates this event? What data field or fields are changing or being updated due to this event?

Again, it all depends upon what your DB table looks like and what you are trying to accomplish.

HTH