note 32214 deleted from function.ocifetchinto by sixd
| From: | sixd@php.net | Date: | Wed, 18 Nov 2009 22:51:11 +0000 |
| Subject: | note 32214 deleted from function.ocifetchinto by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-163056@lists.php.net to get a copy of this message | ||
Note Submitter: gid <gid at gifpaste.net>
----
With oracle 9i, setting the NLS_DATE_FORMAT variable under Linux didn't want to work with
command line php. I tried export before running php, and putenv inside of php.
So I used the ALTER SESSION command instead to make the date fields return the date AND time by
default. Running the query "ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD
HH24:MI:SS'" worked like a charm. And it remains effective throughout entire oracle
session.