title: nls_date_format for postgres
body: <p>We are trying to port a couple of decades worth of Oracle code to Postgres. </p>
  
  <p>Our Oracle code sets NLS_DATE_FORMAT = 'mm/dd/yy', which has the nice effect that whenever a date column appears in a select statement, it is automatically formatted "mm/dd/yy".  </p>
  
  <p>The closest I can find to that in Postgres is  SET DATESTYLE TO SQL,US; but that causes date fields to be returned like " 07/17/2012 16:41:42.109852 EDT".  </p>
  
  <p>Yes, I can modify each of many hundreds of SQL statements to use to_char() or other casts, but does Postgres really not have this simple ability to customize the default output format for dates?</p>