Skip to Content
1
Aug 19, 2013 at 07:03 PM

getdate() vs. current_date() in a user-defined function in ASE 15.0.3

184 Views

Hi.

ASE 15.0.3 apparently doesn't allow getdate() inside a UDF. I thought I understood why: deterministic vs. nondeterministic blah blah blah. (I've worked around this by creating a view that selects getdate() and then letting the UDF select from that view, but that's not relevant to my question.)

I just discovered that current_date() and current_time() ARE allowed in a UDF. Aren't those just as nondeterministic as getdate()? What's up with that?

Thanks.

- John.