DBAL-852: [GH-557] fix date format on oracle #2089

Closed
doctrinebot opened this Issue Mar 28, 2014 · 2 comments

2 participants

@doctrinebot

Jira issue originally created by user @doctrinebot:

This issue is created automatically through a Github pull request on behalf of Tobion:

Url: #557

Message:

The expected format for DATE columns is 01-MAR-14. See http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT413

It also works with 01-Mar-2014 as this PR uses.

We found the problem when trying something like

$this->oracleCon->executeQuery(
    'SELECT * FROM table WHERE datefield > ?',
    array(new \DateTime()),
    array(Type::DATE)
);

which was raising an oracle error that the date could not be parsed.

The

@doctrinebot

Comment created by @doctrinebot:

A related Github Pull-Request [GH-557] was closed:
#557

@doctrinebot

Issue was closed with resolution "Invalid"

@doctrinebot doctrinebot added the Bug label Dec 7, 2015
@deeky666 deeky666 was assigned by doctrinebot Dec 7, 2015
@doctrinebot doctrinebot closed this Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment