SQLite query time period of data problems solved!

Recently engaged in SQLite local query, the requirement is to query the data for a time period, in SQL we know that:

[SQL]View Plaincopyprint?

1. SELECT * from tblname where rdate between ' 2008-6-10 ' and ' 2008-6-12 ' /c3>

SELECT * from Tblname where rdate between ' 2008-6-10 ' and  ' 2008-6-12 '

This is not a problem, but in SQLite we do not have the result of writing, tried many times finally found in the law, we wrote as follows:

[SQL]View Plaincopyprint?

1. SELECT * from tblname where rdate between ' 2008-06-10 ' and ' 2008-06-12 '

SELECT * from Tblname where rdate between ' 2008-06-10 ' and  ' 2008-06-12 '

This is OK, so the rule is that our time must be formatted, so we introduced the following code to format the time:

[SQL]View Plaincopyprint?

2. <pre class="sql" name="code" ><pre class="sql" name="code" ><pre class="  Java " name=" code "> SimpleDateFormat sdf=new simpledateformat (" Yyyy-mm-dd ");
4. Cur_calender.  set (year, month, day );
6. Switch (sel_date_type) {
8. Case 1://start time
10. if (search_date_begin!=null) {
12. Date_start =sdf.format (Cur_calender.gettime ());
14. Search_date_begin.settext (Date_start);
16. }
18. Break
20. Case 2://End time
22. if (search_date_end!=null) {
24. Date_end = Sdf.format (Cur_calender.gettime ());
26. Search_date_end.settext (Date_end);
28. }
30. Break
32. Default:
34. Break
36. }
38. } </pre>
40. <p><br>
42. It's OK now! <br>
44. </p>
46. <p> </p>
48. <pre></pre>
50. <pre></pre>
52. <pre></pre>
54. <pre></pre>
56. <pre></pre>
58. </pre></pre>,

Original address: http://blog.csdn.net/zz_mm/article/details/7453925

SQLite query time period of data problems solved!