TAN() Function in MySQL Last Updated : 09 Dec, 2020 Comments Improve Suggest changes Like Article Like Report TAN() function : This function in MySQL is used to return the tangent of a specified number. In any right triangle, the tangent of an angle is the length of the opposite side divided by the length of the adjacent side. Similarly, this can also be defined as tangent of x is the sine of x divided by the cosine of x, where x is the angle. Syntax : TAN(number) Parameter : This method accepts a parameter as given below as follows. number - Specified numeric value. Returns : It returns the tangent of a specified number. Example-1 : The tangent of 1 is 1.5574077246549023. SELECT TAN(1); Output : 1.5574077246549023 Example-2 : The tangent of 0 is 0. SELECT TAN(0); Output : 0 Example-3 : The tangent of -3 is 0.1425465430742778. SELECT TAN(-3); Output : 0.1425465430742778 Example-4 : The tangent of 3 is -0.1425465430742778. SELECT TAN(3); Output : -0.1425465430742778 Application : This function is used to return the tangent of a specified number. Comment More infoAdvertise with us Next Article TAN() Function in MySQL K Kanchan_Ray Follow Improve Article Tags : SQL DBMS-SQL mysql Similar Reads OCT() function in MySQL OCT() function in MySQL is used to convert decimal number to octal. It returns equivalent octal value of a decimal number. Syntax : OCT(number) Parameter : This method accepts only one parameter. number : The decimal number which we want to convert. Returns : It returns octal value of a decimal numb 2 min read SIGN() Function in MySQL SIGN() function in MySQL is used to return the sign of the given number. It returns 1 if the number is positive, -1 if the number is negative and 0 for zero. Syntax : SIGN(X) Parameter : SIGN() function accepts one parameter as input and will give you the results in values like Positive(+1),Negative 1 min read TRIM() Function in MySQL TRIM() function in MySQL is used to clean up data. It is also used to remove the unwanted leading and trailing characters in a string. Syntax : TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str) Parameter : This method accepts three-parameter as mentioned above and described below : BOTH | LEADIN 2 min read TIME() Function in MySQL The TIME() function in MySQL is used to extract the time portion from a date or datetime expression, returning the time in the format 'HH:MM'. This function is particularly useful when working with time components in databases, such as scheduling or logging systems. In this article, We will learn ab 4 min read SQRT() Function in MySQL The SQRT() function in MySQL calculates the square root of a non-negative number, returning NULL for negative inputs. It is a built-in function that provides high precision and is optimized for performance and making it ideal for mathematical and scientific applications.In the article, we will cover 3 min read Like