to the specified value n. Example: SELECT FLOOR(4.88) = 4 Calculates the natural (i.e., base e) logarithm of n. Examples: LOG(n) SELECT LOG(4.67) = 1.54 SELECT LOG(0.12) = –2.12 Calculates the logarithm (base 10) for n. Examples: LOG10(n) SELECT LOG10(4.67) = 0.67 SELECT LOG10(0.12) = Returns the value PI() of the number pi (3.14). Calculates the x^y. Examples: SELECT POWER(x,y) POWER(3.12,5) = 295.65 SELECT POWER(81,0.5) = 9 Converts degrees to radians. Examples: SELECT RADIANS(n) RADIANS(90.0) = 1.57 SELECT RADIANS(42.97) = 0.75 Returns a random number between 0 RAND and 1 with a FLOAT data type.
to the specified value n. Example: SELECT FLOOR(4.88) = 4 LOG(n) Calculates the natural (i.e., base e) logarithm of n. Examples: SELECT LOG(4.67) = 1.54 SELECT LOG(0.12) = –2.12 LOG10(n) Calculates the logarithm (base 10) for n. Examples: SELECT LOG10(4.67) = 0.67 SELECT LOG10(0.12) = PI() Returns the value of the number pi (3.14). POWER(x,y) Calculates the x^y. Examples: SELECT POWER(3.12,5) = 295.65 SELECT POWER(81,0.5) = 9 RADIANS(n) Converts degrees to radians. Examples: SELECT RADIANS(90.0) = 1.57 SELECT RADIANS(42.97) = 0.75 RAND Returns a random number between 0 and 1 with a FLOAT data type.
1.0%20SQL-SERVER_Notes.docx