Quote:
Originally Posted by Alky
select date_entered from data_table where date_entered < Date_Sub(now(),interval 10 day) group by date_entered
its something like that, it didn't test it though. date_entered is obviousley a column in your table holding date info.
|
i don't have any tables to select from..
all i can use is curdate() and date_sub or other mysql commands..
but no table to select from..
so, today we are 2007.06.15.. i wand the query to retourn dates from 2007.06.15 to 2007.06.05, one day on each row..