Home Forums Programming General math functions in SQL? RE: math functions in SQL?
Lynn Pettis
SSC Guru
Points: 442467
More actions
April 24, 2007 at 1:19 pm
#702242
LOG in Excel defaults to base 10, where as LOG in SQL is the Natural Logarithm (same as ln in Excel) of a number. In SQL you need to use LOG10.
hth