I'm having some problems with getting today's date into a udf. I've read that you can not use getdate inside a udf b/c it is non-deterministic. So what are my options?
In the where clause of my udf I've got:
mytable.mydatetimefield>=CONVERT(CHAR(8), GETDATE(), 112)