sql 查询当天,本月，本周的记录代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】 sql 查询当天,本月，本周的记录

作者:Dezai.CN / 发布于2012/2/21/ 659

<div><span><span class="comment"><span id="1329794219237S" style="display: none;"></span>--查询当天：</span><span>  </span></span></div>
<div><span><span class="keyword">select</span><span> * </span><span class="keyword">from</span><span> info </span><span class="keyword">where</span><span> DateDiff(dd,datetime,getdate())=0  </span></span></div>
<div><span>  </span></div>
<div><span><span class="comment">--查询24小时内的:</span><span>  </span></span></div>
<div><span><span class="keyword">select</span><span> * </span><span class="keyword">from</span><span> info </span><span class="keyword">where</span><span> DateDiff(hh,datetime,getDate())<=24  </span></span></div>
<div><span>  </span></div>
<div><span><span class="comment">--info为表名,datetime为数据库中的字段值</span><span> </span></span></div>
<div></div>
<div></div>
<div></div>
<div><span><span class="comment">--查询当天记录另类的方法</span><span>  </span></span></div>
<div><span><span class="keyword">SELECT</span><span> *  </span></span></div>
<div><span><span class="keyword">FROM</span><span> j_GradeShop  </span></span></div>
<div><span><span class="keyword">WHERE</span><span> (GAddTime </span><span class="op">BETWEEN</span><span> </span><span class="func">CONVERT</span><span>(datetime, </span><span class="func">LEFT</span><span>(GETDATE(), 10) + </span><span class="string">' 00:00:00.000'</span><span>)   </span></span></div>
<div><span>      <span class="op">AND</span><span> </span><span class="func">CONVERT</span><span>(datetime, </span><span class="func">LEFT</span><span>(GETDATE(), 10) + </span><span class="string">' 00:00:00.000'</span><span>) + 1)  </span></span></div>
<div><span><span class="keyword">ORDER</span><span> </span><span class="keyword">BY</span><span> GAddTime </span><span class="keyword">DESC</span><span>   </span></span></div>
<div></div>
<div><span id="1329794219918E" style="display: none;"></span></div>

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　当天,本月，本周的记录　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)