title: split string in sql query
body: <p>I have a value in field called "postingdate" as string in <code>2009-11-25, 12:42AM IST</code> format, in a table named "Post". </p>
  
  <p>I need the query to fetch the details based on date range. I tried the following query, but it throws an error. Please guide me to fix this issue. Thanks in advance.</p>
  
  <pre><code>select postingdate 
  from post 
  where TO_DATE(postingDate,'YYYY-MM-DD')&gt;61689 
    and TO_DATE(postingDate,'YYYY-MM-DD')&lt;61691
  </code></pre>