0

I have the decimal values in my snowflake table and need to show exponential values

0.9525816643 --> 9.523E-1

0.9714426928 --> 9.714E-1

759023.356783 --> 7.59023E5

Which function I can use in snowflake to convert decimal to exponential value?

user2517214
  • 25
  • 2
  • 7

1 Answers1

2

To display numbers in this way you would need to cast them to text/char using an appropriate formatting string e.g. TO_CHAR(1234, '9D999EE')

It's described in a bit more detail here

NickW
  • 8,430
  • 2
  • 6
  • 19