convert string to integer

homer.favenir · #1 (**permalink**) 06-25-08, 03:52

hi,
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

Code:

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'

ive tried to search on different forums and also in mysql manual but it seems i cannot find the answer.

please advice,

thanks

r937 · #2 (**permalink**) 06-25-08, 06:08

you're trying to convert the sum of times to seconds

try summing the conversion of each time to seconds instead

Internet Services

Web Development

Digital Marketing

Consumer Tech