select pump_name, station_id, device_code, pump_number, duration, from bas_pump_work_duration where start_time between 2022-06-17 00:00:00 and 2022-06-17 23:59:59

It looks like you're trying to execute an SQL query, but there is an error in the syntax. The error is likely caused by missing quotes around the date values in the WHERE clause. Here is the corrected query with quotes added:

SELECT pump_name, station_id, device_code, pump_number, duration 
FROM bas_pump_work_duration 
WHERE start_time BETWEEN '2022-06-17 00:00:00' AND '2022-06-17 23:59:59'

This query selects the pump name, station ID, device code, pump number, and duration from the `bas_pump_work_duration` table where the start time is between midnight and 11:59:59 PM on June 17th, 2022.