title: Spring Batch using >= and < in Where Clause
body: <p>Trying hands on with Spring Batch to read data which is created only yesterday. Below is the bean I am trying to use, using JdbcPagingItemReader &amp; SqlPagingQueryProviderFactoryBean. However, the query isn't getting executed.</p>
  
  <p>Appreciate your help!</p>
  
  <pre><code>&lt;bean id="customersPagingItemReader"
      class="org.springframework.batch.item.database.JdbcPagingItemReader"
      scope="step"&gt;
      &lt;property name="dataSource" ref="dataSource" /&gt;
      &lt;property name="queryProvider"&gt;
          &lt;bean
              class="org.springframework.batch.item.database.support.SqlPagingQueryProviderFactoryBean"&gt;
              &lt;property name="dataSource" ref="dataSource" /&gt;
              &lt;property name="selectClause" value="SELECT CUST_ID, CREATED " /&gt;
              &lt;property name="fromClause" value=" from CUSTOMERS" /&gt;
              &lt;property name="whereClause" value=" where CREATED &amp;gt;= trunc(SYSDATE-1) and CREATED &amp;lt; trunc(SYSDATE)" /&gt;
          &lt;/bean&gt;
      &lt;/property&gt;
      &lt;property name="pageSize" value="5" /&gt;
      &lt;property name="fetchSize" value="5" /&gt;
      &lt;property name="rowMapper"&gt;
          &lt;bean class="com.yahoo.affiliationapi.api.CustomerRowMapper" /&gt;
      &lt;/property&gt;
  &lt;/bean&gt;
  </code></pre>