COT() Function in MySQL Last Updated : 09 Dec, 2020 Comments Improve Suggest changes Like Article Like Report COT() function : This function in MySQL is used to return the cotangent of a specified number. If the specified number is 0, an error or NULL will be returned. In a right triangle, the cotangent of an angle is the length of it's adjacent side divided by the length of the opposite side. Similarly, this can also be defined as cotangent of x is the cosine of x divided by the sine of x, where x is the angle. Syntax : COT(number) Parameter : This method accepts a parameter as given below as follows. number - Specified numeric value. Returns : It returns the cotangent of a specified number. Example-1 : The cotangent of 1 is 0.6420926159343306. SELECT COT(1); Output : 0.6420926159343306 Example-2 : The cotangent of 0 returns an errors. SELECT COT(0); Output : Error in SQL: DOUBLE value is out of range in 'cot(0)' Example-3 : The cotangent of -3 is 0.6420926159343306. SELECT COT(-3); Output : 7.015252551434534 Example-4 : The cotangent of 3 is -7.015252551434534. SELECT COT(3); Output : -7.015252551434534 Application : This function is used to return the cotangent of a specified number. Comment More infoAdvertise with us Next Article COT() Function in MySQL K Kanchan_Ray Follow Improve Article Tags : SQL DBMS-SQL mysql Similar Reads COUNT() Function in MySQL The COUNT() function in MySQL is a versatile aggregate function used to determine the number of rows or non-NULL values that match a specific condition in a query. It can be applied to an entire table or a particular column and is widely used in database operations to analyze the volume of data in a 3 min read CONCAT() function in MySQL CONCAT() function in MySQL is used to concatenating the given arguments. It may have one or more arguments. If all arguments are nonbinary strings, the result is a nonbinary string. If the arguments include any binary strings, the result is a binary string. If a numeric argument is given then it is 2 min read ELT() Function in MySQL In this article, we are going to cover ELT function with examples. In ELT function, number field will state that how many strings will be there. ELT function in MySQL is used to returns the string which is at index number specified in the argument list. In this function there is number field and str 1 min read EXTRACT() Function in MySQL The EXTRACT() function in MySQL is a versatile tool used for retrieving specific components of date Whether we need the year, month, day or even the hour or minute. This function simplifies date manipulation and makes queries involving date and time data more efficient and easier to understand. In t 3 min read CURTIME() function in MySQL CURTIME() function in MySQL is used to check the current time. It returns the current time as a value in âhh:mm:ssâ or 'hhmmss' format, depending on whether the function is used in a string or numeric context. Syntax : CURTIME(fsp) Parameters : This method accepts only one parameter. fsp - It specif 2 min read Like