Selecting date range
I'm trying to select a range of dates, something like:
select * from table where dateColumn between currentDate and currentDate - 35
Any hints? Thanks!
Should work in MySQL, not 100% sure about other DBMS's:
SELECT * FROM table_name WHERE date_column BETWEEN CURDATE() AND DATE_ADD(CURDATE, INTERVAL 25 DAY)
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)