Menu
How can I come up with a stored procedure that selects results for past 30 days?
where MONTH(RequestDate) > 6 and DAY(RequestDate) >= 10 and MONTH(RequestDate) < 21 and DAY(RequestDate) < 7 
704
To get yesterday's date, you need to subtract one day from today's date. Use GETDATE() to get today's date (the type is datetime ) and cast it to date . In SQL Server, you can subtract or add any number of days using the DATEADD() function. The DATEADD() function takes three arguments: datepart , number , and date .
Here's the SQL query to get records from last 7 days in MySQL. In the above query we select those records where order_date falls after a past interval of 7 days. We use system function now() to get the latest datetime value, and INTERVAL clause to calculate a date 7 days in the past.
Bookmark this question. Show activity on this post. SELECT * FROM product WHERE pdate >= DATEADD(day, -30, getdate()).
SELECT * FROM Table WHERE GETDATE() >= DATEADD(DAY, -30, GETDATE()) Substitute the first GETDATE() with the appropriate column name.
SELECT * FROM Table WHERE Table.ColumnName >= DATEADD(DAY, -30, GETDATE()) Are you looking for last 30 days or last month? To find start and end of each month ("generic" as your comment says), use:
select dateadd(month,datediff(month,0,getdate()),0), dateadd(mm,datediff(mm,-1,getdate()),-1) If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
