Skip to content

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

Comments

  • edited November 2023

    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.

This discussion has been closed.