Power Function Rounds Off

• Tom Hannah

  SSC Rookie

  Points: 36

  More actions

  March 10, 2006 at 7:09 pm

  #189714

  I am writing a program that needs to calculate 10 raised to variable exponential values. The power function, however, rounds everything off to integers. I can't do things like fine 10 raised to .0001 or even 10 raised to 2.5. Does anybody know how to get around this? I have tried casting

   

• peterhe

  SSChampion

  Points: 11469

  More actions

  March 14, 2006 at 6:56 am

  #626485

  The returned data type is the same as the first parameter in the Power function. So you cannot pass integer 10  as the first paramter. Try this:

  SELECT

  POWER(10.0000000000, 0.00001)