Get total hours worked in a day mysql

by 
SELECT `User_id`, time(sum(`Date_time`*(1-2*`in_out`)))
  FROM `whatever_table` GROUP BY `User_id`;

The (1-2*`in_out`) term gives every login event a -1 factor and every logout event a +1 factor. The sum function takes the sum of the Date_time column, and GROUP BY `User_id` makes that the sum for each different user is created.

More Related Contents:

  1. MySQL Query GROUP BY day / month / year
  2. Error in MySQL when setting default value for DATE or DATETIME
  3. Difference between two dates in MySQL
  4. MySQL Query to select data from last week?
  5. Datetime equal or greater than today in MySQL
  6. How to convert number of week into date?
  7. Set NOW() as Default Value for datetime datatype?
  8. Group mysql query by 15 min intervals
  9. SQL Query to show nearest date?
  10. How to get current date & time in MySQL?
  11. how to cast the hexadecimal to varchar(datetime)?
  12. MySQL: Insert datetime into other datetime field
  13. INSERT INTO SELECT statement with more columns which is not in another table
  14. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  15. 1052: Column ‘id’ in field list is ambiguous
  16. How to split the name string in mysql?
  17. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  18. Cumulative sum over a set of rows in mysql
  19. Add Auto-Increment ID to existing table?
  20. MySQL SELECT DISTINCT multiple columns
  21. How to copy a row and insert in same table with a autoincrement field in MySQL?
  22. Using group by on two fields and count in SQL
  23. Can MySQL convert a stored UTC time to local timezone?
  24. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  25. MySQL CONCAT returns NULL if any field contain NULL
  26. Does Order of Fields of Multi-Column Index in MySQL Matter
  27. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  28. How to change string date to MySQL date format at time of import of CSV using MySQL’s LOAD DATA LOCAL INFILE
  29. MySQL optimizing INSERT speed being slowed down because of indices
  30. Update multiple rows with multiple ‘where’ clauses for each individual row

Leave a Comment