#47128 [NEW]: NLS_DATE_FORMAT

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