From: iteam dot soft at gmail dot com
Operating system: Red Hat 8.0
PHP version: 5.2.8
PHP Bug Type: *General Issues
Bug description: NLS_DATE_FORMAT
Description:
------------
For about a week ago I had installed on my box Apache 2.2.10 with PHP
5.2.7. Beside this the php was compiled with FirebirdSql and Oracle
Instant Client.
On apache start I put a env variabile
export NLS_DATE_FORMAT=DD.MM.YYYY
On my application start point from PHP I also double ensure the
NLS_DATE_FORMAT it's set so I put also
putenv('NLS_DATE_FORMAT=DD.MM.YYYY');
Everything was ok and my application display the date format from
oracle as I set it. All good.
Last week ... I made upgrade to Apache 2.2.11 and PHP 5.28.
After upgrade nothing change to my application or configuration only
this applications (apacheand and php) as I mentioned above.
>From this point the date format that I was getting from Oracle was
NOT what I set.
The returned date format was in Oracle standard DD-M-RR.
So I try everything .. recheck ... reset env variables .. put extra
configuration for php ... but no result. The same bad date.
I know I could use the alter session as a work-arround ... but this
envolves running the alter session eache time user wants information
from the database. The application it's huge and with a lot of users
and it's running on the intranet system.
So I preffer the PUTENV method.
So all was ok until the upgrade from apache 2.2.10 to 2.2.11 and php
5.2.7 to 5.2.8
Reproduce code:
---------------
I try all this ... at once and one by one ... no result.
$_ENV["NLS_DATE_FORMAT"] = 'DD.MM.YYYY';
putenv('NLS_DATE_FORMAT=DD.MM.YYYY');
apache_setenv('NLS_DATE_FORMAT=DD.MM.YYYY');
Expected result:
----------------
The Oracle date format to be:
22.01.2009
Actual result:
--------------
22-JAN-09
--
Edit bug report at http://bugs.php.net/?id=47128&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=47128&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=47128&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=47128&r=trysnapshot60
Fixed in CVS:
http://bugs.php.net/fix.php?id=47128&r=fixedcvs
Fixed in CVS and need be documented:
http://bugs.php.net/fix.php?id=47128&r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=47128&r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=47128&r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=47128&r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=47128&r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=47128&r=support
Expected behavior:
http://bugs.php.net/fix.php?id=47128&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=47128&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=47128&r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=47128&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47128&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=47128&r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=47128&r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=47128&r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=47128&r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=47128&r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=47128&r=mysqlcfg
