title: How to display date in a different format in oracle
body: <p>I have a table with a date field. By default, <code>select max(date) from table;</code> returns the date in 'dd-mmm-yy' format. How do I select the date in 'MM/DD/YYYY' format, without changing the table 's structure or the field's format.</p>
  
  <p>Thanks,
  Supraja</p>