|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #10350 OCIResult doesn't return time for an Oracle Date field
Submitted: 2001-04-16 16:07 UTC Modified: 2006-04-04 06:25 UTC
From: dwilson at cae dot wisc dot edu Assigned: maxim (profile)
Status: Not a bug Package: OCI8 related
PHP Version: 4.0.3pl1 OS: *
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: dwilson at cae dot wisc dot edu
New email:
PHP Version: OS:


 [2001-04-16 16:07 UTC] dwilson at cae dot wisc dot edu
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.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2001-04-16 17:48 UTC]
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:


 [2003-01-29 09:03 UTC]
Besides being a little bit bogus, this also has chances to be already solved meanwhile.
 [2006-04-04 06:25 UTC]
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Sat Jan 18 15:01:23 2020 UTC