SQL Server function parameters

Question

I have a function that takes two parameters of type date like this

FUNCTION [dbo].[fn_Test] (@DiffFrom DATE, @DiffTo DATE) 
RETURNS INT

but when I try to run

SELECT [fn_Test](convert(date, 'Oct 23 2012 11:01AM') ,  GETDATE())

I get the following error:

Incorrect syntax near the keyword 'convert'.

What am I doing wrong?

Lucero · Accepted Answer · 2016-10-19 23:20:47Z

5

You need to qualify the function name like this:

SELECT [dbo].[fn_Test](convert(date, 'Oct 23 2012 11:01AM') ,  GETDATE())

answered Oct 19, 2016 at 23:20

Lucero

60.4k9 gold badges127 silver badges154 bronze badges

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

1 Answer 1