![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.05 » View Incident Report |
![]() |
Reported By: Michael Fullerton Reported On: 3/21/2011 For: Version 2.05 Build 4 |
SELECT WorkDate, SUM(CASE WHEN EXTRACT(DAYOFWEEK FROM WorkDate)=1 THEN HOURS ELSE 0 END) AS Mon, [...] SUM(CASE WHEN EXTRACT(DAYOFWEEK FROM WorkDate)=0 THEN HOURS ELSE 0 END) AS Sun, SUM(Hours) AS Total FROM ETime GROUP BY WorkDate
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |