Help setting up stored procedure

#1

I'm trying to get all records that are 7 days pass duedate
(fieldname)

Select * from Library
where duedate > getdate()

How do I get it to show only records that are 7 days pass getdate?

Thanks!

#2

Try something like this:

SELECT duedate
FROM Library
WHERE duedate < DATEADD(day, DATEDIFF(day, 0, CURRENT_TIMESTAMP) - 7, 0)

HTH,

Plamen Ratchev
http://www.SQLStudio.com

#3

On Feb 26, 2:50*pm, "Plamen Ratchev" <Pla... (AT) SQLStudio (DOT) com> wrote:

Quote:

Try something like this:

SELECT duedate
FROM Library
WHERE duedate < DATEADD(day, DATEDIFF(day, 0, CURRENT_TIMESTAMP) - 7, 0)

HTH,

Plamen Ratchevhttp://www.SQLStudio.com

Pefect...Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Help setting up stored procedure

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Help setting up stored procedure - 02-26-2008 , 01:27 PM

Re: Help setting up stored procedure - 02-26-2008 , 01:50 PM

Re: Help setting up stored procedure - 02-26-2008 , 02:04 PM