convert string to integer

[homer.favenir]

hi to all,
well, this is just a simple question that i cant answer.

how can i convert string to intger?

my query is

format(sum(time_to_sec(timediff(key_entry_log.time_end, key_entry_log.time_start)))/3600,2)
as 'Total Man Hours'

my 'total man hours' was not recognize as integer coz it didnt sum up.
please advice

thanks

 

[Dravu]

hi to all,
well, this is just a simple question that i cant answer.

how can i convert string to intger?

my query is

format(sum(time_to_sec(timediff(key_entry_log.time_end, key_entry_log.time_start)))/3600,2)
as 'Total Man Hours'

my 'total man hours' was not recognize as integer coz it didnt sum up.
please advice

thanks

Add "+0" or "*1" to simply change a string to a number.