title: Setting a default date format on PostgreSQL
body: <p>Good afternoon,</p>
  
  <p>Many of you may already know that it is possible, for instance, in Oracle set the default date format used by formatting functions (ie to_char), just like this:</p>
  
  <pre><code>ALTER SESSION SET NLS_DATE_FORMAT='SYYYY/MM/DD~HH24:Mi:SS'
  </code></pre>
  
  <p>My question is: is there any equivalence for this on PostgreSQL. I have been searching for an answer without success although I have found some references to the PostgreSQL locale settings (http://www.postgresql.org/docs/7.4/static/charset.html). Anyhow, I have been unable to figure out an answer.</p>
  
  <p>Any suggestions? Thank you in advance and best wishes for this holidays!</p>