如何在asp.net中从数据库中检索过去一周的数据 [英] how to retrieve data of past week from database in asp.net

问题描述

先生;

请帮助我：

我正在为学校制作网络应用程序。所以我想显示学生的每周进度报告。请告诉我只有查询用于此目的的sql。



提前感谢...

hi sir;
please help me:
I am making a web application for school. So i want to display weekly progress report of students. please tell me only query of sql that is used for this purpose.

thanks in advance...

推荐答案

查询非常简单：

The query is pretty simple:

SELECT * FROM MyTable WHERE myDateColumn BETWEEN DATEADD(week, DATEDIFF(week,0,GETDATE())-1,-1) AND DATEADD(week, DATEDIFF(week,0,GETDATE()),-1)

它看起来很复杂！



错过了BETWEEN：doh： - OriginalGriff [/ edit]

It just looks complex!

[edit]Missed out the BETWEEN :doh: - OriginalGriff[/edit]

这篇关于如何在asp.net中从数据库中检索过去一周的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！