#5642 [Csd->Bgs]: OCI functions do not work with Oracle's to_date($string, format) function
| From: | tony2001@php.net | Date: | Mon, 17 Jul 2006 08:09:38 +0000 |
| Subject: | #5642 [Csd->Bgs]: OCI functions do not work with Oracle's to_date($string, format) function | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-99499@lists.php.net to get a copy of this message | ||
ID: 5642
Updated by: tony2001@php.net
Reported By: jnguyen at scrtec dot org
-Status: Closed
+Status: Bogus
-Bug Type: Oracle related
+Bug Type: OCI8 related
Operating System: Digital UNIX V5.0 (Rev. 910)
PHP Version: 4.0 Release Candidate 2
Previous Comments:
------------------------------------------------------------------------
[2000-08-25 05:48:21] thies@php.net
php does _not_ touch the string you pass to oracle - please make sure
your NLS_LANG environment is set correct in your apache process.
------------------------------------------------------------------------
[2000-08-23 08:12:05] sniper@php.net
Is this still happening with more recent versions of
php4 (from CVS or snapshot from http://snaps.php.net/ ) ??
--Jani
------------------------------------------------------------------------
[2000-07-17 12:35:31] jnguyen at scrtec dot org
$sql1 = "SELECT id, the_date FROM a_table WHERE the_date <
to_date('01-JAN-99')";
$stmt = OCIparse($conn, $sql1);
OCIexecute($stmt);
while(OCIfetch($stmt)) { ... }
The PHP script above returns everything, including records newer than
01-JAN-99, from the table, whereas when I cut and paste the SQL
statement into SQL*PLUS, the correct number of results is fetched.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=5642&edit=1