#42173 [Opn->Csd]: Query with "INTERVAL DAY TO SECOND" returns false

ID: 42173 Updated by: sixd@php.net Reported By: sixd@php.net -Status: Open +Status: Closed Bug Type: OCI8 related Operating System: n/a PHP Version: 6CVS-2007-08-02 (CVS) Assigned To: sixd New Comment: This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. The fixes were applied to PHP5 and PHP6. Previous Comments: ------------------------------------------------------------------------ [2007-08-02 05:29:51] sixd@php.net Third issue is that the output from oci_field_type() for a TIMESTAMP WITH TIMEZONE column should be changed from TIMESTAMP_TZ to TIMESTAMP WITH TIMEZONE to match standard terminology. ------------------------------------------------------------------------ [2007-08-02 05:23:20] sixd@php.net Description: ------------ Queries for INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND work in PHP5, but the latter returns a null value in PHP6 with unicode.semantics=On due to the outcol storage size being too short. A second issue with PHP5 and PHP6 is that oci_field_type() doesn't know these two types nor the type TIMESTAMP WITH LOCAL TIMEZONE. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=42173&edit=1