records of last 7 days including today

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

records of last 7 days including today

Author

Topic

asifbhura
Posting Yak Master

165 Posts

Posted - 2006-06-14 : 04:28:05

Dear Sir,

I want to have records which are inserted in last 7 days including today.

please help me

waiting for reply.

Regards,
ASIF

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-06-14 : 04:40:45

Select * From TblName where <Date_Column> between DateAdd(dd,-7,GetDate()) And DateAdd(dd,1,GetDate())

Chirag

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-06-14 : 04:47:33

or

Select * From TblName where <Date_Column> >=DateAdd(day,DateDiff(day,0,getdate()),-7)

Madhivanan

Failing to plan is Planning to fail

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-06-14 : 04:52:22

quote:
Originally posted by madhivanan

Select * From TblName where <Date_Column> >=DateAdd(day,DateDiff(day,0,getdate()),-7)

Madhivanan

last seven days including today would look like

Select * From TblName where <Date_Column> >=DateAdd(day,DateDiff(day,0,getdate()),-6)

Select * From TblName where <Date_Column> >DateAdd(day,DateDiff(day,0,getdate()),-7)

Peter Larsson
Helsingborg, Sweden

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-06-14 : 05:06:59

Yes it is. Thanks

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources