I don't think the == is valid in SQL, if you want to test for equality,
just use =.
On 25/07/2011 9:06 PM, saurabh kulkarni wrote:
Why this query is not working??
My date column has date like:2011-07-25.
final Calendar c =
Calendar.getInstance();
int myMonth = (c.get(Calendar.MONTH)+1);
int myDay = c.get(Calendar.DAY_OF_MONTH);
String query = " select * from table1 where (SUBSTR(date,6,2)== " +
myMonth + " AND SUBSTR(date,9,2)= " + myDay + " )
UNION ALL select * from table1 where (SUBSTR(date,6,2)== " + myMonth +
" AND SUBSTR(date,9,2)> " + myDay + " )
UNION ALL select * from table1 where SUBSTR(date,6,2)> " + myMonth +
"
UNION ALL select * from table1 where SUBSTR(date,6,2)< " + myMonth +
"; ";
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
