Tag: duration

SQL: how do you calculate occupancy/ number of in-use for a facility?

I am trying to calculate the number of occupied lockers in the changing room. The dataset goes like this: My ideal output will be the number of occupied lockers per hour: I am able to manually calculate the number in excel (‘no. of check-in lockers during the hour’ + ‘no. of lockers in-use during the hour’ – ‘no. of check-out

How to convert average time returened from sql query to minutes [closed]

duration milliseconds php sql time

I am running the following query SELECT SEC_TO_TIME(AVG(TIME_TO_SEC(Response_Time))) as avg_time FROM Case_report where Reporting_Time between “‘.$fromdate.'” and “‘.$todate.'” and …