select events with dates equal to or greater than one week from today?

Asked Mar 26 '14 at 21:12

Active Mar 26 '14 at 21:30

Viewed 823 times

I have a calendar of events table and I would like to select ALL events with dates equal to or greater than 2 weeks from CURDATE(). I have this

SELECT DATE_FORMAT(tournament_date_start, '%b %e') AS Tournament_Date
FROM tournament_main
WHERE tournament_main.tournament_date_start >= CURDATE()+14
ORDER BY tournament_main.tournament_date_start
LIMIT 5";

But it doesn't go two weeks ahead. I am not sure of how this works. Thanks!

edited Mar 26 '14 at 21:30

Gordon Linoff

1,242,037
58
646
786

asked Mar 26 '14 at 21:12

AaronK

What's the format of `tournament_date_start`? – jeroen Mar 26 '14 at 21:15
What datatype are you using for tournament_date_start ? – Mark Baker Mar 26 '14 at 21:15
1

Did you try: `CURDATE() + interval 14 days`? – Gordon Linoff Mar 26 '14 at 21:30
you'll find useful this post http://stackoverflow.com/questions/2793619/mysql-query-working-with-interval-and-curdate – Olvathar Mar 26 '14 at 21:38
Success! Gordon-- I had the change "DAYS" to "DAY" and it worked. I found another line of questions that specified the use of DAY vs. DAYS and that did the trick! – AaronK Mar 27 '14 at 14:34

select events with dates equal to or greater than one week from today?

0 Answers0