Show details in database for particular date

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hi,,

plz help me,...

in sql database, i have a table in that have one column having date....

i need to view the data only before 7days to that date in Database...

example:

------------------------------------------------
date exam subject
------------------------------------------------
13/7/2012 Annual English
14/7/2012 Annual Science
------------------------------------------------

i can view the first row data only when system date is between 6/7/2012 to 13/7/2012
and 2nd row data can visible only between 7/7/2012 to 14/7/2012

is it possible? plz give me the query...

Posted 20-Jul-12 2:31am

Raajendran

Add a Solution

Comments

Vasim889 20-Jul-12 8:54am

actually what is your problem and please detail explanation?

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

abhinavvijay · Accepted Answer · 2012-07-20T03:25:00

Solution 2

you can also tried below statement:

select * from table where Date between dateadd(DD,-7,getdate()) and getdate()

Posted 20-Jul-12 3:25am

abhinavvijay

Jim Jos · Accepted Answer · 2012-07-20T03:19:00

Solution 1

Could try the following query

SQL

select * from table where Date between DATEADD(DD, -7, SYSDATETIME()) AND SYSDATETIME()

Posted 20-Jul-12 3:19am

Jim Jos

Show details in database for particular date

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Show details in database for particular date

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us