[Koha-bugs] [Bug 31150] _on or _date for DB date columns?

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Sep 29 00:18:04 CEST 2022


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31150

Fridolin Somers <fridolin.somers at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |fridolin.somers at biblibre.co
                   |                            |m

--- Comment #9 from Fridolin Somers <fridolin.somers at biblibre.com> ---
I'd say the "xxx_date" may be confusing because it is a data format.
Using "xxx_on" is more specific to say "xxx field as been modified on this
date".
Plus have "created_on", "modified_on", "deleted_on".
SQL Comments can always explain more.

We will have to discuss some existing occurrences like :
reserves.cancellationdate
branchtransfers.date*

"_on" +1

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.


More information about the Koha-bugs mailing list