I m trying to write a function that calculates date difference as follows:

ALTER FUNCTION dbo.daycount(@startday DateTime)
RETURNS Integer AS
BEGIN

DECLARE @enddate DateTime
Select @enddate = GetDate()

RETURN DATEDIFF(day, @startday, @enddate)

END


keeps saying I can't use GetDate(). Can someone tell me what's wrong with this?

PS, I just did some search on web. Everyone is saying you cant using it in SQL2k.

Question is, there any way around it?

Built in function s that are non deterministic can't be nested in another
UDF .The getdate() function is non deterministic as it returns a different
result every time with the same parameters/


--
----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________


"axism" <axism.27pc60 (AT) no-mx (DOT) forums.yourdomain.com.au> wrote

Jack is correct. Nondeterministic functions CANNOT
be used within user defined functions. What might help,
though, is that the DateTime() function can be passed to
the user defined function as a parameter.

Try altering your function to accept this passed in value.