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

ID: 42173 Updated by: sixd@php.net Reported By: sixd@php.net Status: Open Bug Type: OCI8 related Operating System: n/a PHP Version: 6CVS-2007-08-02 (CVS) Assigned To: sixd New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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