Is there a function similar to GETDATE to use in UDFs

[phellis]

I'm trying get a result set based on the current system time. In normal instanced this is just a case of using GETDATE().
However, due to the limitations of UDF's the GETDATE function can not be called. Does anybody know of a work around that will return a System Date to a UDF.

 

[rasx]

There is of course the option of passing the value of GETDATE() as a parameter to the function. If great accuracy is required this option is not viable.

Bryan Wilhite
rasx@kintespace.com

http://www.kintespace.com/kb