sql-server-2008 - sql server 2008如何计算一年中的天数

Question

我想在 SQL Server 2008 Management Studio 中计算一年中的天数。

例如:

• 2016 年:366
• 2014 年:365

Answer 1

你可以试试:

  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