[Koha-bugs] [Bug 7806] New: Illegal dates are used to signal non existing dates.

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7806

          Priority: P5 - low
 Change sponsored?: ---
            Bug ID: 7806
          Assignee: gmcharlt at gmail.com
           Summary: Illegal dates are used to signal non existing dates.
        QA Contact: koha.sekjal at gmail.com
          Severity: major
    Classification: Unclassified
                OS: All
          Reporter: marc at msys.ch
          Hardware: All
            Status: NEW
           Version: unspecified
         Component: Database
           Product: Koha

The illegal date '0000-00-00' is being used in Koha to signal a non-existing
date.  MySQL allows for such illegal dates.  A database like PostgreSQL, which
is much more strict when it comes to correct data, does not allow illegal
values as date values.

If a date is inexistant/invalid etc. an SQL NULL must be used instead.

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