title: Oracle - get current date formatted
body: <p>I've been wondering - I have a lot of use with sysdate on my system, and when comparing it to my date columns I have to use trunc(sysdate) since the format of sysdate is <code>DD/MM/YYYY HH24:MI:SS</code> .</p>
  
  <p>I looked over the internet for other functions to return current date on format of <code>DD/MM/YYYY</code> but had no luck, <code>current_date , current_timestamp</code> and ETC also gives me the hours format..</p>
  
  <p>I need this for better performance when comparing an indexed date column to the current date.</p>
  
  <p>So , anybody know of a system function that returns the desired format? or a way to bypass it?</p>