String Conversions

Comments

3 comments

  • Comment actions Permalink
    Official comment
    Avatar
    Matthias Korn

    Hi Chris,

    this behaviour comes directly from Java, see here:
    https://stackoverflow.com/questions/1450991/how-to-do-an-integer-parseint-for-a-decimal-number

    As a workaround, would this be sufficient for you? It will cut off the decimal part.
    SELECT CONVERT(CONVERT('100.900', float),integer)

    Best,
    Matthias

  • 0
    Comment actions Permalink
    Avatar
    Chris Shortt

    Hello,

    The idea is to type less (i.e. not work so hard for something so simple). While the behavior comes directly from Java, how hard could it be to override Java to make your user's life a bit easier?

    Anyway, thanks for the feedback.

    Chris

  • 0
    Comment actions Permalink
    Avatar
    Salvatore Raunich

    Hi Chris,

    thanks for your feature request and for your feedback.

    We will further discuss it in Product Management.

    Best

    Salvatore

Please sign in to leave a comment.

Powered by Zendesk