title: Oracle: Similar to sysdate but returning only time and only date
body: <p>I understand that Oracle sysdate returns the current date AND time. That's great for timestamp or datetime columns.</p>
  
  <p>Now let's say I have a DATE only column. What keywords should I use on my insert query?</p>
  
  <pre><code>insert into myTable1(myDateOnlyColumn) values(???)
  </code></pre>
  
  <p>And let's say I have a TIME only column. What keywords should I use on my insert query?</p>
  
  <pre><code> insert into myTable2(myTimeOnlyColumn) values(???)
  </code></pre>
  
  <p>Thanks!</p>