Unanswered: convert string to integer
i have a simple question but i cant figure it out.
i want my result to be in grand summary it.
but it didnt summarize. i think it sees my result as string and not an integer.
my code is
ive tried to search on different forums and also in mysql manual but it seems i cannot find the answer.
format(time_to_sec(SUM(CASE WHEN key_entry_log.time_end > '16:00'
THEN key_entry_log.adjustment_time ELSE 0 END))/3600,2) as 'ot hours'
Take Nothing But Pictures;
Leave Nothing But Footprints;
Kill Nothing But Time;