× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

field "timeupdated"

7 months 2 weeks ago #10223 by Ivo Huissen
field "timeupdated" was created by Ivo Huissen
Hi,

field "timeupdated" seems to change regardless if something actually changes. Is this default behavior or am i missing something here?

Please Log in or Create an account to join the conversation.

7 months 3 days ago #10244 by barbraten
Replied by barbraten on topic field "timeupdated"
If the "timeupdated" field is associated with a database table, the database management system (DBMS) may automatically update timestamp fields with the current time whenever a record is modified or inserted, even if no actual data changes. This is often referred to as a "timestamp" or "last modified" field, and it's a common feature in database systems.

Please Log in or Create an account to join the conversation.

7 months 3 days ago #10246 by Ivo Huissen
Replied by Ivo Huissen on topic field "timeupdated"
The field time_updated should be the same as the standard joomla content field modified. Both are datetime fields, not timestamp fields as such. One would expect same behavior. If nothing changes nothing is updated/modified. Now this field makes no sense whatsoever and one could as well use a timestamp type instead. Modification does not equal hitting a save button.

Please Log in or Create an account to join the conversation.

7 months 3 days ago #10247 by Ivo Huissen
Replied by Ivo Huissen on topic field "timeupdated"
I stand myself corrected, same happens with the joomla modified field. Both wrong IMHO.

Please Log in or Create an account to join the conversation.

Time to create page: 0.237 seconds
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.