SQL: how to display records in just 30 days

Question

I tried to use

SELECT * from Results
WHERE DATEDIFF(d,Date,getdate())<30

But this seems like a mistake.

Only 30 days will be displayed for each registered entry. Can I find out if my syntax is correct?

Famous, Stan

Answer 1

The syntax looks fine, but you may need to quote Date:

SELECT * from Results WHERE DATEDIFF(d, [Date], getdate()) < 30

Do you have a Date in Results column?

BTW, which will not be able to use the index, whereas it will be:

SELECT * from Results WHERE [Date] >= DATEADD(d, -30, getdate()) 

Answer 2

-, ( ) SQL. SQL Server, SQL Server (.. GetDate()).

JohnFx Jet SQL:

SELECT *  
FROM results 
WHERE ([Date] between DateAdd("d", -30, Date()) and Date())

, "" Access/Jet. WHERE :

WHERE (results.Date between DateAdd("d", -30, Date()) and Date())

- "", .

, , Jet , . - , ( ), :

WHERE results.Date BETWEEN results.Date-30 AND Date()

, JohnFx DateDiff(), DateAdd .

Jet, , DateAdd() ( "d" ) SQL Server (GetDate ( )), Jet (Date()). Jet/Access SQL, , , "results.Date-30" , DateAdd().

: , , , SQL, , SQL. , ( , , ).

Answer 3

:

SELECT *  
FROM results 
WHERE ([Date] between DateAdd("d", -30, Date()) and Date())

-. "" Access - , , . , [] .

Answer 4

Microsoft Access, (), getdate() ( SQL Server).

Answer 5

. , ?

Answer 6

You did not specify SQL Server as your dB. In Access, the syntax is DateAdd: DateAdd ("d", 1, "31-Jan-95").