Noobie Question: GetDate() in UDF

• Dennis-509860

  Old Hand

  Points: 351

  More actions

  August 9, 2011 at 11:35 am

  #390154

  Hi everybody,

  I always thought that

  1) non-deterministic functions weren't allowed in user-defined functions

  2) Getdate() is non-deterministic

  3) Therefore I shouldn't be able to use it in a function,

  but this compiles just fine:

  create function dbo.bbb ()

  returns datetime

  as

  begin

  return getdate();

  end;

  What am I not seeing here?

  Thanks!

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 9, 2011 at 11:40 am

  #1366105

  Welcome to 2k5 +.

  It was still like you expected in 2000.

• Dennis-509860

  Old Hand

  Points: 351

  More actions

  August 9, 2011 at 12:36 pm

  #1366157

  Yeah, I noticed this "improvement" in 2005, but I couldn't find any documentation as to why this suddenly "works". I haven't taken the time to test other such functions...