Inline table function

[New baba]

Hello,
I have an inline table function and it takes tow parameters of type VARCHAR.
It functions when I hardcode to string within of call like this:
SELECT * FROM dbo.TestTable(‘a’, ‘b’)

Here is definition of inline table function:

FUNCTION GetIPTimeRangeTable (@StartDate VARCHAR(10) = '', @EndDate VARCHAR(10) = '')
RETURNS TABLE
AS
RETURN
(
SELECT
* FROM UserDataSetsAccess
WHERE 1 = 1
AND CreatedAT between @StartDate AND @EndDate
)

If call function like this:
SELECT * FROM GetIPTimeRangeViewTable('2008-7-1', '2008-7-11')
Every ting is OK but if I call function like this
SELECT * FROM GetIPTimeRangeViewTable('2008-7-1', CONVERT(CHAR(10), GETDATE(),121))
I get error:
Incorrect syntax near the keyword 'CONVERT'.
Do you have any explanation for that! Tanks

[iburyak]

I tried this and it worked

Declare @A datetime
select @A = CONVERT(CHAR(10), GETDATE(),121)
SELECT * FROM dbo.GetIPTimeRangeTable('2000-08-06', @A)

It is true function is not accepted in a table function as a parameter.

Good Luck.

[New baba]

Tanks man, isn’t a bizarre situation anyway?

[iburyak]

Tanks man, isn’t a bizarre situation anyway?

I am not a man.... :) But anyway I saw such behavior in other places so we have to work with what we have.