There is such a simple WORK table, there are so few fields, respectively is the repair order ID, employee ID, start time, finish time, as follows,

WORK_ID EMP_ID START_TIME FINISH_TIME
. . . .
Better 1024 52 2021-04-08 when 2021-04-08
He 1025 68 2021-04-09 2021-04-09 15:08
At 19:00 1026 33 2021-04-09 comes to 2021-04-09
. . . .

I want to check on April 9 processing time more than three hours? What are those? What kind of statement to query?

CodePudding user response:

The 2021-04-09 23:00 2021-04-09 5:00
The 2021-04-09 22:00 2021-04-09 1:01
The 2021-04-09 at about 2021-04-09 10:01
The 2021-04-09 at about 2021-04-09 1:01
The four respectively count?