#10350 [Opn->Bgs]: OCIResult doesn't return time for an Oracle Date field

ID: 10350 Updated by: tony2001@php.net Reported By: dwilson at cae dot wisc dot edu -Status: Open +Status: Bogus -Bug Type: Feature/Change Request +Bug Type: OCI8 related Operating System: * PHP Version: 4.0.3pl1 Assigned To: maxim New Comment: . Previous Comments: ------------------------------------------------------------------------ [2003-01-29 09:03:31] maxim@php.net Besides being a little bit bogus, this also has chances to be already solved meanwhile. ------------------------------------------------------------------------ [2001-04-16 17:48:13] cnewbill@php.net 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] 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. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=10350&edit=1