北京奥运会开幕已过去多少天?正确的T-SQL语句是()A? ?...
北京奥运会开幕已过去多少天?正确的T-SQL语句是()
A SELECT DATEDIFF(DAY,'2008-08-08',GETDATE()) AS 天数
B SELECT DATEDIFF(d,'2008-08-01',GETDATE())
C SELECT DATEADD(DAY,'2008-08-08',GETDATE()) AS 天数
D SELECT DATENAME(DAY,'2008-08-08',GETDATE()) AS 天数