title: Convert field timestamp data to a java.sql Date in jooq
body: <p>I retrieve timestamp type data from the mysql table. but I just need to return only the date part of this timestamp. Tried in convering timestamp to a date data type. But in jooq this gives some errors.Here is what I retrieve</p>
  
  <pre><code> Field&lt;Timestamp&gt; transaction_date = LINKLK_TRANSACTIONS.MODIFIED_AT.as("transaction_date");
  </code></pre>