I having been looking for a way of converting a string to an integer and in doing so I have read most if not all the posts concerning this process. After reading the OS reference documents I am no further to getting a solution.
What I ave is an SQL table and one of the fields contains "time" data which could be in the format of "+10:00" or "-4:30". In ideal circumstances the data I am being feed would be of the "int" type but unfortunately it is of the type "varchar". I need to split the string into parts so I can add the hours and minuets to the current time.
I have written the code for the split but I think I need to change the data from a string to an integer, is this possible, if so can anyone point me in the right direction.
I having been looking for a way of converting a string to an integer and in doing so I have read most if not all the posts concerning this process. After reading the OS reference documents I am no further to getting a solution.
What I ave is an SQL table and one of the fields contains "time" data which could be in the format of "+10:00" or "-4:30". In ideal circumstances the data I am being feed would be of the "int" type but unfortunately it is of the type "varchar". I need to split the string into parts so I can add the hours and minuets to the current time.
I have written the code for the split but I think I need to change the data from a string to an integer, is this possible, if so can anyone point me in the right direction.