Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
open:en:alv [2018/04/19 13:21] Gerben Gieling |
open:en:alv [2018/04/20 14:06] Gerben Gieling |
||
|---|---|---|---|
| Line 8: | Line 8: | ||
| select event_id,detail,date_format(start_date,'%d-%m-%Y') as alv_date | select event_id,detail,date_format(start_date,'%d-%m-%Y') as alv_date | ||
| from agenda_events | from agenda_events | ||
| - | where event_type_id='a' and start_date>=now() | + | where event_type_id='a' and datediff(start_date,now()) >= 0 |
| order by detail asc | order by detail asc | ||
| limit 1 | limit 1 | ||