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

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); <dwilson@cae.wisc.edu> wrote in message news:20010416200754.31077.qmail@php2.chek.com... > From: dwilson@cae.wisc.edu > 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: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >