JDBC_MySQL_StoredFunction2
Function :ctof , Centigrade to Fahrenheit conversions.

Code :

CREATE DEFINER=`Manas9`@`%`
FUNCTION `ctof`(i NUMERIC(4,2)) RETURNS decimal(4,2)
BEGIN
DECLARE t1 NUMERIC(4,2) ;
set t1 = ((i * 9/5)+32);
RETURN t1;

END

Code Snippet:

Callable statement:

 

Runtime display/output: