Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-2731

Error when inserting in oracle DB : ORA-01861: literal does not match format string

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Security Level: All
    • Labels:
      None
    • Environment:
      Symfony2 - Doctrine2 - Linux

      Description

      I moved my project from MySQL to Oracle, and I get this error when I try to insert into the database.

      This error is caused by the date format, in my form the date format is dd/mm/yyyy, so my question is HOW DOES SYMFONY2 GET THE DATE FORMAT BEFORE DB INSERT?

      I added this date_default_timezone_set("Europe/Paris"); to my config.php and app_dev.php, but nothing changed.

      An exception occurred while executing 'INSERT INTO arborescence (IDNT_ARBR, NOM_ARBR, DATE_CREATION, IDNT_SERV, IDNT_UTLS) VALUES (?, ?, ?, ?, ?)' with params [7, "B", "2013-10-09 00:00:00", 7, 1]:

      ORA-01861: literal does not match format string

      Any ideas on how to solve this would be really appreciated.

        Activity

        Abdelghafour IFTAH created issue -
        Abdelghafour IFTAH made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Abdelghafour IFTAH
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: