Bug 39894 - Bookings not also correctly set to the beginning or end of each day
Summary: Bookings not also correctly set to the beginning or end of each day
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal
Assignee: Martin Renvoize (ashimema)
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-05-13 21:47 UTC by Lucas Gass (lukeg)
Modified: 2025-06-20 16:36 UTC (History)
4 users (show)

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function: Bookings


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Lucas Gass (lukeg) 2025-05-13 21:47:30 UTC
I had some trouble recreating this one but here goes:

To recreate:
1. In your koha-conf.xml set the timezone to:
<timezone></timezone>

2. Enable bookings and make an item or itemtype bookable.
3. Place a booking and have a look at the start_date and end_date in the DB:
select start_date, end_date from bookings;
4. This might look something like:

2025-05-13 02:00:00 | 2025-05-15 01:59:59

So depending on your timezone and time of day the booking end_date might creep into the next day which causes confusion.