| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.5.0b4 |
| Request #17354 | Timestamp fields should also have ISO date format | ||
|---|---|---|---|
| Submitted: | 2010-04-28 19:12 UTC | ||
| From: | koto | Assigned: | |
| Status: | Open | Package: | MDB2_Driver_oci8 (version 1.4.1) |
| PHP Version: | Irrelevant | OS: | |
| Roadmaps: | (Not assigned) | ||
[2010-04-28 19:12 UTC] koto
(Krzysztof Kotowicz)
Description:
------------
When connecting to database in function _doConnect() with default settings, date format for datetime fields is set to ISO:
ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
However, timestamp fields retain their default format depending on server-side set locale. To prevent that, one should also issue query:
ALTER SESSION SET NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SS'
This query should be placed in _doConnect() method right next to the previous one. This is a short few-line change that would help everyone dealing with timestamp fields in Oracle (as now they can be safely altered/read/parsed with MDB2_Date )