How to iterate in this query?
- by Umaid
for (int I=-1; I<30; I++)
{
for (int J=0; J<30; J++)
{
for(int K=1; K<30; K++)
{
SELECT rowid,Month, Day, Advice from MainCategory where Month= 'May ' and Day in ((cast(strftime('%d',date('now','+(I) day')) as Integer)),(cast(strftime('%d',date('now','+(J) day')) as Integer)),(cast(strftime('%d',date('now','+(K) day')) as Integer)));
}
}
}
And for the same reason how to decrement in this query
for (int I=-1; I<30; I--)
{
for (int J=0; J<30; J--)
{
for(int K=1; K<30; K--)
{
SELECT rowid,Month, Day, Advice from MainCategory where Month= 'May ' and Day in ((cast(strftime('%d',date('now','(I) day')) as Integer)),(cast(strftime('%d',date('now','(J) day')) as Integer)),(cast(strftime('%d',date('now','(K) day')) as Integer)));
}
}
}
