note 32214 added to function.ocifetchinto

From: Date: Tue, 20 May 2003 18:00:22 +0000
Subject: note 32214 added to function.ocifetchinto
Groups: php.notes 
Request: Send a blank email to php-notes+get-48675@lists.php.net to get a copy of this message
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. ---- Manual Page -- http://www.php.net/manual/en/function.ocifetchinto.php Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+32214 Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+32214&report=yes Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+32214&report=yes

« previous php.notes (#48675) next »