Forums Register Login

Calculate Working hours

+Pie Number of slices to send: Send
Hello,

I am using the below sql query to calculate working hours. The problem which i am facing is that query is taking lot of time to calculate the working hours. Please help to reduce the execution time of this query or if there is any other way to calculate working hours

The following query take 63.499 sec


please help me how do i change the query to reduce the sec.

Bakthavachalam E
+Pie Number of slices to send: Send
+Pie Number of slices to send: Send
ok
thanks for your reply
If you open the box, you will find Heisenberg strangling Shrodenger's cat. And waving this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1283 times.
Similar Threads
how do get particular date of total time
how do i compare row by row
Query problem with MySQL 5
org.hibernate.exception.GenericJDBCException: could not insert:
how to compare row by row
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 09:11:58.