TO_TIME Conversion giving negative values
Having some issues with the TO_TIME() function I'm getting negative values and the wrong values on some of the values.
when i activate my function to convert the int values to time values, two of the variables get the wrong value like this:
And before i activate the function the default values are like this:
Is this a bug or a feature? anyone got any ideas?
Might it be the swedish characters in the variables... :)
Best regards
Mike
This discussion has been closed.
Comments
Hi!
You faced with datatype overflow when multiply integer variable before type conversion.
You should provide explicit conversion of datatype before operation and/or use exact constant declaration (implicit type conversion)
Best regards.
Thank you for the quick response! It works now.