-
using getdate() in an UDF
Is it right, that getdate() cannot be used in an user defined function. if so, then how do i get hte current date and time in my function?
-
Rather than getting current date within the function using getdate(), pass getdate() value to the function.
-
declare @x datetime
set @x=getdate()
select * from tb1 where udfdatex(@x)=1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|