php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #42173 Query with "INTERVAL DAY TO SECOND" returns false
Submitted: 2007-08-02 05:23 UTC Modified: 2007-08-02 19:07 UTC
From: sixd@php.net Assigned: sixd (profile)
Status: Closed Package: OCI8 related
PHP Version: 6CVS-2007-08-02 (CVS) OS: n/a
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: sixd@php.net
New email:
PHP Version: OS:

 

 [2007-08-02 05:23 UTC] 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-08-02 05:29 UTC] 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 19:07 UTC] sixd@php.net 
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.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Nov 21 11:01:29 2024 UTC