http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7806
Priority: P5 - low
Change sponsored?: ---
Bug ID: 7806
Assignee: [email protected]
Summary: Illegal dates are used to signal non existing dates.
QA Contact: [email protected]
Severity: major
Classification: Unclassified
OS: All
Reporter: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
