title: Bad date format Oracle SQL
body: <p>I'm facing an issue with date format. I need the row with the max(date1)
  I don't think that my query is incorrect :</p>
  
  <pre><code>SELECT column1, 
      column2, 
      date1
  FROM table
  WHERE date1 = (SELECT MAX(date1) FROM table);
  </code></pre>
  
  <p>When i use this query in dev environment with TOAD, i'm receiving that result : </p>
  
  <blockquote>
    <p>column1;column2;date1 </p>
    
    <p>aaaaa;bbbbb;19/09/2014 14:13:21</p>
  </blockquote>
  
  <p>But, when i ask our infrastructure to make this query in production, they returned me that result :</p>
  
  <blockquote>
    <p>column1;column2;date1</p>
    
    <p>ccccc;dddddd;14/09/26</p>
  </blockquote>
  
  <p>The date isn't in good format... What can i do the receive the good date ? Does i have to specified the format in my query ? Or does the infra team messed up somethings while giving me the result ?</p>
  
  <p>Thanks in advance for your help</p>