title: How to use Date in Hybris Flexible Search Query?
body: <p>I am trying to fetch records from hybris using Flexible Search query based on date. I tried to find some resources for the same but none worked out.</p>
  
  <p>Basically, I am trying to find products where modified date is equals to the current date.</p>
  
  <p>My current query is:</p>
  
  <pre><code>Select * from {product as p} where to_char({p.modifiedDate},'dd/mm/yyyy')==to_char('18/04/2017','dd/mm/yyyy')
  </code></pre>
  
  <p>This is my current query.
  However, when I run this using HAC, it give me error:</p>
  
  <pre><code>xception message: ORA-00936: missing expression
  Exception stacktrace:
  oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776) oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897) 
  </code></pre>
  
  <p>Can anyone help me out on this ?</p>