title: Unable to use SUBSTR inside TO_DATE in Derby Embedded Database
body: <p>I am using derby embedded database for my Maven test cases. And I am not able to use SUBSTR inside TO_DATE, its giving error.</p>
  
  <p>Actually it was used for original application which is connected to oracle db. Now I am writing Maven test cases, with derby embedded db and unable to execute this one. The thing is I should not modify the original query and I need some workaround to rectify this issue.</p>
  
  <p>My query will be like this.</p>
  
  <p>SELECT TO_DATE (SUBSTR (testdate, 1, 9), 'DD-MM-RR') FROM testtable</p>
  
  <p>Please help me on this issue. Thanks.</p>