Changes between Version 2 and Version 3 of UseCase4

Timestamp:

02/11/25 01:06:53 (3 weeks ago)

Author:

212054

Comment:

--

UseCase4

@@ -26 +26 @@
     SELECT 
         pn.Podizveduvac_Ime,
-        TIMESTAMPDIFF(HOUR, FROM_UNIXTIME(rn.Od_vreme), FROM_UNIXTIME(rn.Do_vreme)) AS Total_Hours_Worked,
-        TIMESTAMPDIFF(HOUR, FROM_UNIXTIME(rn.Od_vreme), FROM_UNIXTIME(rn.Do_vreme)) * pn.Saatnica AS Total_Cost
+        TIMESTAMPDIFF(HOUR, rn.Od_vreme, rn.Do_vreme) AS Total_Hours_Worked,
+        TIMESTAMPDIFF(HOUR, rn.Od_vreme, rn.Do_vreme) * pn.Saatnica AS Total_Cost
     FROM Raboti_Na rn
     JOIN Podizveduvac pn ON rn.Podizveduvac_Ime = pn.Podizveduvac_Ime
@@ -42 +42 @@
     WHERE nz.Objekt_ID = input_Objekt_ID
     GROUP BY d.Dobavuvac_Ime;
-END
+END;
 }}}