new_time function in SQL Server 2005

Is there a function or a workaround in SQL Server 2005 that is equivalent to the new开发者_运维问答_time() function in oracle?

---

No, there is not equivalent functionality to Oracle's NEW_TIME() function in SQL Server 2005. It was added to SQL Server 2008 - DATETIMEOFFSET.

CLR UDF would be the most likely alternative.