title: How to remove leading zeroes from day and month values in Oracle, when parsing to string using to_char function?
body: <p>I want to retrieve a date without the leading zeroes in front of the day and month values in a select statement. If I execute the following query</p>
  
  <pre><code> select to_char(sysdate, 'dd.mm.yyyy') from dual;
  </code></pre>
  
  <p>I will get 21.03.2014 as a result. Moreover, if today was, for example, 7th of March, 2014, I would get 07.03.2014. How can I get rid of these leading zeroes?</p>