Sqlserver 推算（日,周,月,季度,年统计）

<div class="blogpost-body" id="cnblogs_post_body">
 
<div>
 <pre class="blockcode"><a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=DECLARE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">DECLARE</a> @dt <a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=datetime&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">datetime</a>
<a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=SET&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">SET</a> @dt=GETDATE()
<a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=DECLARE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">DECLARE</a> @number <a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=int&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">int</a>
<a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=SET&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">SET</a> @number=1

--1．指定日期该年的第一天或最后一天
--第一天为月日、最后一天为月日都是固定的
 --A. 年的第一天
 <a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=SELECT&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">SELECT</a> <a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=CONVERT&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">CONVERT</a>(<a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=char&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">char</a>(5),@dt,120)+'1-1'AS '年第一天'
 --B. 年的最后一天
 <a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=SELECT&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">SELECT</a> <a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=CONVERT&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">CONVERT</a>(<a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=char&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">char</a>(5),@dt,120)+'12-31'AS '年最后一天'

--2．指定日期所在季度的第一天或最后一天
--A. 季度的第一天
<a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=SELECT&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">SELECT</a> <a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=CONVERT&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">CONVERT</a>(<a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=datetime&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">datetime</a>,
<a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=CONVERT&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">CONVERT</a>(<a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=char&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">char</a>(8),
 DATEADD(<a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=Month&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99" style="color:#0000ff;">Month</a>,
 DATEPART(Quarter,@dt)*3-<a href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW

Sqlserver 推算（ 日,周,月,季度,年统计）

浏览过的版块

Sqlserver 推算（日,周,月,季度,年统计）