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);
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> From: [EMAIL PROTECTED]
> Operating system: Sun OS 5.7
> PHP version: 4.0.3pl1
> PHP Bug Type: Feature/Change Request
> Bug description: OCIResult doesn't return time for an Oracle Date field
>
> 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.
>
>
>
> --
> Edit Bug report at: http://bugs.php.net/?id=10350&edit=1
>
>
>
> --
> 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]
>
--
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]
