title: Why my SQLite request in java code output only months from October(&&/10/&&)?
body: <p>Case: In my SQLite database date store as DATE type. Iam trying to show records from current month and if that month is 10, 11 or 12 everything is working but month from 1 to 9 is giving empty output.</p>
  <p>'''</p>
  <pre><code>    LocalDate ld = LocalDate.now();
      int yearNumber = ld.getYear();
      int monthNumber = ld.getMonth().getValue();
  
      String queryString = &quot;SELECT &quot; +
              &quot; *, &quot; +
              &quot;strftime('%m', DAY_DATE) as Month, &quot; +   //  getting number of month from 01 to 12 
              &quot;strftime('%Y', DAY_DATE) as Year   &quot; +   // getting number of year
              &quot; FROM &quot; + DAYS_TABLE +
              &quot; WHERE &quot;+&quot;Month&quot; +
              &quot; LIKE &quot;  + monthNumber +
              &quot; AND &quot; + &quot;Year&quot;+
              &quot; LIKE &quot; + yearNumber +
              &quot; ORDER BY &quot; + COLUMN_DAY_DATE +
              &quot; DESC &quot; ;
  </code></pre>
  <p>'''</p>
  <p>What should i use to see records from each month?</p>