https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37902
Bug ID: 37902
Summary: Timezone ignored when passing rfc3339 formatted date
(search 'q')
Change sponsored?: ---
Product: Koha
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: REST API
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
2. GET /api/v1/jobs?q={"enqueued_on":{">":"2024-09-04T09:26:52-03:00"}}
is generating the following query
SELECT `me`.`id`, `me`.`status`, `me`.`progress`, `me`.`size`,
`me`.`borrowernumber`, `me`.`type`, `me`.`queue`, `me`.`data`, `me`.`context`,
`me`.`enqueued_on`, `me`.`started_on`, `me`.`ended_on`
FROM `background_jobs` `me`
WHERE `enqueued_on` > '2024-09-04T09:26:52-03:00'
But when you run it manually, you get a warning:
| Warning | 1292 | Truncated incorrect datetime value:
'2024-09-04T09:26:52-03:00' |
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://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/