title: how to set cuurent DB time in jooq record object
body: <p>I have generated jooq records via the code generator. In my record I have a timestamp field which I want to set as the DB current dat time.</p>
  
  <p>The below works:</p>
  
  <pre><code>MyRecord myrecord = new MyRecord();
  myrecord.setCreateTime(Timestamp.from(Instant.now())); 
  </code></pre>
  
  <p>But I want to use the DB time , so something like this:(obviously there is a compile error in the below syntax)</p>
  
  <pre><code>myrecord.set(MY_RECORD.CREATE_TIME, DSL.currentTimestamp());
  </code></pre>
  
  <p>What is the best way to achieve this?</p>