Loop from date to date
Posted: Thu May 28, 2009 9:29 pm
hi to all
how to use from date to date for looping.
my date format (YY/MM/DD)
I have a date from 2009/01/05 to 2010/03/20
I want to execute into my sql query are
then next loop:
until to satisfied "to date (2010/03/20)";
any suggestion would greatly appreciated
thanks in advance
Tirso
how to use from date to date for looping.
my date format (YY/MM/DD)
I have a date from 2009/01/05 to 2010/03/20
I want to execute into my sql query are
Code: Select all
select * from mytable where date_created between 2009/01/05 and 2009/01/31 //for 2009/01 (january 2009) recordsCode: Select all
select * from mytable where date_created between 2009/02/01 and 2009/02/31 //for 2009/01 (february 2009) recordsany suggestion would greatly appreciated
thanks in advance
Tirso