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/

Reply via email to