开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜