如何用SQL语句实现查找近三天的记录(25分)

D

Delphi 6.0

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-19

• #1

我建了一个表，其中一个字段是 "输入时间"
2002/06/20
2002/06/19
2002/06/18
2002/06/17
字段里的记录为日期。
现在要求用SQL语句实现查找近三天的记录。就是 当前日期-数据中的日期=3.请问用SQL
语句如何实现？

 

Q

qdyoung

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-19

• #2

sqlserver语法：
select * from t where datediff(dd, datefiled, getdate())=3
-----
http://www.8421.org

 

K

kkyy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-19

• #3

DateDiff函数。
---
http://www.delphibbs.com/delphibbs/dispq.asp?lid=1144133

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-20

• #4

select * from t where rq>:rq
parambyname('rq').asdatetime:=date-3

 

E

Expert

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-20

• #5

select * from t where getdate()-输入时间<=3

 

L

lphjj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-20

• #6

SQL语法：SELECT * FROM DB_HIRE WHERE DATEDIFF(DAY,DATAFIELD,GETDATE())<=3