String Conversions

Not planned

Follow

0

Chris Shortt

• September 03, 2021 12:30

Hello,

How is it that 

  SELECT CONVERT('100.000',bigdecimal)

works just fine and

   SELECT CONVERT('100.000',integer)

fails?

You should fix this.

Thanks.

Chris

• Comment actions Permalink

  Official comment

  

  Matthias Korn

  • September 07, 2021 08:30

  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

  

  Chris Shortt

  • September 07, 2021 08:33

  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

  

  Salvatore Raunich

  • September 09, 2021 17:08

  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.