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.
精彩评论