title: How can I alter NLS_DATE_FORMAT in PHP
body: <p>How can I alter the NLS_DATE_FORMAT from an Oracle database using PDO.
  So far I have this:</p>
  
  <pre><code>    $date_set = "DD-MM-YYYY HH24:MI:SS";
      $query = $this-&gt;conn-&gt;prepare("ALTER SESSION SET 'NLS_DATE_FORMAT' = ?");
      $query-&gt;execute(array($date_set));
  </code></pre>
  
  <p>But when I try to fetch the session:</p>
  
  <pre><code>    $query = "select * from nls_session_parameters where parameter='NLS_DATE_FORMAT'";
      $parameters = array();
      $test = $this-&gt;fetchRow($query, $parameters);
      var_dump($test); exit();
  </code></pre>
  
  <p>it returns:</p>
  
  <p>DD-MON-RR"</p>