Syntax error in sql create function

Question

I'm getting the following error whenever i'm trying to create the following function in mysql. error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

And my function is

    CREATE FUNCTION GET_HOUR_MINUTES(seconds INT)
    RETURNS VARCHAR(16)
    BEGIN
    DECLARE result VARCHAR(16);
    IF seconds >= 3600 THEN SET result = TIME_FORMAT(SEC_TO_TIME(seconds),'%kh %lm');
    ELSE SET result = TIME_FORMAT(SEC_TO_TIME(seconds),'%lm');
    RETURN result;
    END

score 1 · Accepted Answer · 2014-04-07 09:20:22Z

1

You need to change the delimiter before creating a function. If you don't your CREATE statement terminates at the first semi-colon.

Try this:

DELIMITER $$

CREATE FUNCTION GET_HOUR_MINUTES(seconds INT)
    RETURNS VARCHAR(16)
    BEGIN
    DECLARE result VARCHAR(16);
    IF seconds >= 3600 THEN SET result = TIME_FORMAT(SEC_TO_TIME(seconds),'%kh %lm');
    ELSE SET result = TIME_FORMAT(SEC_TO_TIME(seconds),'%lm');
    END IF
    RETURN result;
    END$$

DELIMITER ;

Thanks to @Ravinder for catching the missing END IF.

edited Apr 7, 2014 at 9:20

answered Apr 7, 2014 at 8:01

user1864610

Sign up to request clarification or add additional context in comments.

1 Comment

Ravinder Reddy Over a year ago

Add END IF before RETURN statement. And it should be working.

Collectives™ on Stack Overflow

Syntax error in sql create function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related