Bug 10899

Summary: "creation_date" in "news -> edit/create" displays 02/00/0 when the date inputed is 08/11/1940
Product: Koha Reporter: Olli-Antti Kivilahti <olli-antti.kivilahti>
Component: ToolsAssignee: Galen Charlton <gmcharlt>
Status: CLOSED INVALID QA Contact: Testopia <testopia>
Severity: trivial    
Priority: P5 - low CC: jonathan.druart
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Olli-Antti Kivilahti 2013-09-17 13:51:56 UTC
When setting the "creation_date" in "news -> edit/create" to 08/11/1940,
in all views it is shown as 02/00/0.
02/00/0 is the "uh-oh there is no valid date."

mysql database value is "opac_news.timestamp = 0000-00-00 00:00:00"
Comment 1 Owen Leonard 2014-09-24 14:38:13 UTC
I assume the bug affects any date before 1970-01-01. I also assume the issue is moot in practical terms because no system would have posted news before 1970.
Comment 2 Olli-Antti Kivilahti 2014-09-24 15:25:42 UTC
Hence the trivial importance :)

Thanks for commenting anyway!
Comment 3 Jonathan Druart 2015-04-22 10:01:02 UTC
That's not a bug, the creation date is stored into opac_news.timestamp