title: Java Oracle date
body: <pre><code>String sql="select id from period where '"+systemDate+"' between startDate and endDate";
  </code></pre>
  
  <p>I need to execute this query and I am using oracle 10g. I want to get the id which falls between these dates. Problem I am facing is in oracle my date format is"dd-mon-yy" and systemDate is in format yyyy-mm-dd.So is ther any way to convert java date to dd-mon-format or any other way to execute the above query...</p>
  
  <p>Kindly help.</p>