I have dates stores in format 0000-00-00
How do I query dates only older or equal to today's date?
Something like this:
"where date =< date()" ???
Thanks
Ron
Query all records ordered by date but no knewer than today's
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
You could do:
http://www.mysql.com/doc/en/Date_and_ti ... tions.html
Mac
Code: Select all
SELECT field1, field2, field3 FROM table WHERE date <= CURDATE()Mac