ID: 47128
Updated by: [email protected]
Reported By: iteam dot soft at gmail dot com
-Status: Open
+Status: Bogus
Bug Type: *General Issues
Operating System: Red Hat 8.0
PHP Version: 5.2.8
New Comment:
And you immediately assume your bad configuration is a bug in
PHP..pff..
Previous Comments:
------------------------------------------------------------------------
[2009-01-16 14:55:23] iteam dot soft at gmail dot com
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 this bug report at http://bugs.php.net/?id=47128&edit=1
