title: How to set NLS_DATE_FORMAT | ZF2 with oci8 | Oracle 12
body: <p>I'm working with ZendFramework2 and my DB is Oracle 12.</p>
  
  <p>I would like to set the date format for all my date fields.</p>
  
  <p>For now, when i select a date field the result is dd/mm/aa, i would like dd/mm/yyyy hh24:mi:ss.</p>
  
  <p>( i'm using TableGateway object the same way Zf2's Skeleton Application )</p>
  
  <p>Can i do that in my config file ?</p>
  
  <p>( The sql code to do that whould be "alter session set nls_date_format = 'DD/MM/YYYY HH24:MI:SS'; "
  )</p>
  
  <p>Thanks for help.</p>
  
  <pre><code>&lt;code&gt;
  ------
  config\autoload\db.config.global.php
  ------
  &lt;?php
  return array(
    'db' =&gt; array(
      'driver' =&gt; 'OCI8',
      'connection_string' =&gt; " (DESCRIPTION =
                                  (SDU = 8888)
                                  (ADDRESS_LIST =
                                    (ADDRESS = (PROTOCOL = tcp)(HOST = 127.0.0.1)(PORT = 9999))
                                  )
                                  (CONNECT_DATA =
                                    (SERVER = DEDICATED)
                                    (SERVICE_NAME = MYDB)
                                  )
                                )",
      'character_set' =&gt; 'AL32UTF8',
    ),
     'service_manager' =&gt; array(
             'factories' =&gt; array(
                 'Zend\Db\Adapter\Adapter'
                         =&gt; 'Zend\Db\Adapter\AdapterServiceFactory'
             )
       )
  );
  &lt;/code&gt;
  </code></pre>