- 1. MySQL: Display Users and Duration in Matrix Timesheet
- / MySQL /
- ... this week, 1 for the week before, 2 for the week before that... $timesheet_query_per_user=" SELECT DISTINCT s.StaffUserID AS 'UserID', ( SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) ...
- Created on 27 April 2012
- 2. MySQL parameters in Excel 2007 PivotTables
- / MySQL /
- ... WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN 'Saturday' ELSE 'Sunday' END AS ActivityDay, DATE(s.DateTimeCreated) ...
- Created on 24 August 2011
- 3. Difference between two dates - the midnight hour
- / Web-Development /
- I might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on ...
- Created on 06 April 2011