dates

[Shaolin]

Hi Guys

I have a table with the following columns:

id, name, start_date, end_date

How can I check whether the current date is inbetween the start/end dates ?

[skywalker2208]

I think it would be start_date >= date you are checking AND end_date <= date you are checking

[Phill Pafford]

Haven't tested


SELECT id, name, start_date, end_date, NOW() AS today
FROM table_name
WHERE today BETWEEN start_date AND end_date
ORDER BY today DESC