ID: 10350
Updated by: cnewbill
Reported By: [EMAIL PROTECTED]
Old-Status: Bogus
Status: Open
Bug Type: Feature/Change Request
PHP Version: 4.0.3pl1
Assigned To:
Comments:
Seeing how it's a feature request, I guess it can't be Bogus or can it?
-Chris
Previous Comments:
---------------------------------------------------------------------------
[2001-04-16 17:48:13] [EMAIL PROTECTED]
Joe Brown says:
This is not a PHP bug.
Consider setting NLS_DATE_FORMAT.
The manual states OCIResult() returns everything as a string.
NLS_DATE_FORMAT may not be appropriate for your needs.
There are quite a few places you can set NLS_DATE_FORMAT.
* Environment variables (or windows registry on win32)
* orclSID.ora
* on a per session basis; execute this statement after logon:
$cursor=OCIParse($connection, "ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD
HH24:MI:SS'");
OCIExecute($cursor);
OCIFreeCursor($cursor);
---------------------------------------------------------------------------
[2001-04-16 16:07:54] [EMAIL PROTECTED]
The Oracle Date fields are actually DateTime fields. Your OCIResult routinue returns
the date only.
As this point, you can't change what OCIResult does because you'd break existing code.
I request that you add a new function allowing the recovery of the time value of an
Orcale Date field.
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10350&edit=2
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]