Bug #10350 Updated: OCIResult doesn't return time for an Oracle Date field

ID: 10350 Updated by: cnewbill Reported By: dwilson@cae.wisc.edu Old-Status: Open Status: Bogus Bug Type: Feature/Change Request PHP Version: 4.0.3pl1 Assigned To: Comments: 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); Previous Comments: --------------------------------------------------------------------------- [2001-04-16 16:07:54] dwilson@cae.wisc.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. --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10350&edit=2