NUMTODSINTERVAL in SQL Server

Is there a function in SQL Server开发者_运维问答 that is the same as NUMTODSINTERVAL in Oracle?

No. In SQL Server time intervals for date arithmetic are always specified as integers. Take a look at the DATEADD and DATEDIFF functions for example. Since intervals are specified as integers you won't need a function to return a special interval type.

No, there is no such function since there is no INTERVAL datatype in MSSQL.