Atif Sheikh (5/6/2009)

---

The question looks like this (at least on my PC)...

SELECT CONVERT(datetime,-1)

UNION

SELECT CONVERT(datetime,0)+CONVERT(datetime,-1)

UNION

SELECT CONVERT(datetime,-1)-CONVERT(datetime,0)

UNION

SELECT CONVERT(datetime,0)-CONVERT(datetime,1)

UNION

SELECT...

Jan Van der Eecken (4/15/2009)

---

Douglas, you are quite correct when you say that MSDN lists all of the above as built-in functions that cannot be used in a UDF because...

The correct answer is no, and I would imagine that the people in power will correct the issue soon. In addition to the explanation given in the answer, the following...