title: Date difference in Amazon Aurora postgres and hsql
body: <p>I am looking for some common approach for taking date difference for hsql and aurora postgres. I know that direct date difference is supported for aurora postgres i.e <code>date1 - date2 &gt; 2</code> works for it but this is not supported in hsql. <code>DATEDIFF('day' , TO_CHAR(sysdate,'yyyy-MM-dd'),TO_CHAR(mysample_date,'yyyy-MM-dd'))</code> is supported in hsql but not in aurora postgres.</p>
  
  <p>Is there any common approach for the same?</p>
  
  <p>Any lead will be appreciated.</p>