SQL query with date? little help [SOLVED]
Posted: Wed Feb 03, 2010 7:52 am
Hey gurus,
I would like to know how to make a query with time involved, online searches are just confusing me and im not getting far. The objective is to create a query which finds all records 7 days old. The dates are stored in the database like "2010-01-31".
So the query would probably have to use curdate() then + 7 days or more, i dunno.
Can anyone give me an example? I appreciate it.
Regards
Tony
I would like to know how to make a query with time involved, online searches are just confusing me and im not getting far. The objective is to create a query which finds all records 7 days old. The dates are stored in the database like "2010-01-31".
So the query would probably have to use curdate() then + 7 days or more, i dunno.
Can anyone give me an example? I appreciate it.
Regards
Tony