我想在 SQL Server 2008 Management Studio 中计算一年中的天数。
例如:
最佳答案
你可以试试:
declare @y int;
set @y = 2014;
SELECT DATEDIFF(day, cast(@y as char(4)), cast(@y+1 as char(4))) Days
结果:
Days
365
2评论版本:
declare @y int;
set @y = 2014;
SELECT DATEDIFF(day, cast(cast(@y as char(4)) as date), cast(cast(@y+1 as char(4)) as date)) DaysCnt
https://stackoverflow.com/questions/31780606/