ID: 10350 Updated by: cnewbill Reported By: [EMAIL PROTECTED] 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] [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]