User defined function sql, Incorrect syntax near the keyword 'return'

Question

I'm trying to write a function that takes an input of a date, and calculates the difference between current day and the inputed date, then returns it as an integer of days. (So if I input yesterday 2015-5-8 it returns 1). So far I'm getting this error and can't really figure out what's wrong. Any help is appreciated.

CREATE FUNCTION DnevnaRazlika
(@OdKdaj nvarchar(15))
RETURNS INT 
AS
BEGIN 
declare @return INT
select @return = DATEDIFF(day,@OdKdaj, CONVERT(date,GETDATE()))
end
return @return 
end

Edit: Using Microsoft SQL management studio

Ardalan Shahgholi · Accepted Answer · 2015-05-08 23:07:34Z

3

Too much ends. try below code

CREATE FUNCTION DnevnaRazlika ( @OdKdaj NVARCHAR(15) )
RETURNS INT
AS 
    BEGIN 
        DECLARE @return INT
        SELECT  @return = DATEDIFF(day, @OdKdaj, CONVERT(DATE, GETDATE()))
        RETURN @return 
    END

edited May 8, 2015 at 23:07

Ardalan Shahgholi

12.7k25 gold badges116 silver badges155 bronze badges

answered May 8, 2015 at 8:56

Robert

25.8k8 gold badges70 silver badges86 bronze badges

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

1 Comment

Daniel L. VanDenBosch Over a year ago

This answer was helpful because it told me that the issue truly was syntax (Although mine for a different reason.). Thank you

Pranay Rana · Accepted Answer · 2015-05-08 08:57:23Z

1

problem here is you are having end two time

CREATE FUNCTION DnevnaRazlika
(@OdKdaj nvarchar(15))
RETURNS INT 
AS
BEGIN 
declare @return INT
select @return = DATEDIFF(day,@OdKdaj, CONVERT(date,GETDATE()))
--end remove this end than it will work 
return @return 
end

answered May 8, 2015 at 8:57

Pranay Rana

177k37 gold badges244 silver badges266 bronze badges

Comments

Prafulla Kumar Sahu · Accepted Answer · 2016-02-13 06:37:52Z

0

create Function a123(@a Int,@b Int) returns Int as 
begin 
    return (@a + @b)
end

select dbo.a123(30,20)

edited Feb 13, 2016 at 6:37

Prafulla Kumar Sahu

9,75911 gold badges78 silver badges116 bronze badges

answered Feb 13, 2016 at 5:38

ajay

11 bronze badge

1 Comment

Alexei - check Codidact Over a year ago

Answers should also include a small explanation, even in the case of very simple ones.

Collectives™ on Stack Overflow

User defined function sql, Incorrect syntax near the keyword 'return'

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related