Breaking News: Grepper is joining You.com. Read the official announcement!

oci_execute(): ORA-01810: format code appears twice in

Alive Antelope answered on October 7, 2020 Popularity 3/10 Helpfulness 7/10

answer oci_execute(): ORA-01810: format code appears twice in

oci_execute(): ORA-01810: format code appears twice in

Comment

//Using oci8 to connect to Oracle Database.
//oci_execute(): ORA-01810: format code appears twice 

SQL> SELECT  TO_TIMESTAMP('20151206 00:00:00', 'yyyy/mm/dd hh:mm:ss') FROM dual;
SELECT  TO_TIMESTAMP('20151206 00:00:00', 'yyyy/mm/dd hh:mm:ss') FROM dual
                                          *
ERROR at line 1:
ORA-01810: format code appears twice
  
//Reason for error is that 'mm' appear in ('yyyymmdd') and ('hh:mm:ss') while 
//minutes are denoted as 'mi and 'mm' as months.

Popularity 3/10 Helpfulness 7/10 Language php

Source: stackoverflow.com

Tags: format php

Link to this answer
Share Copy Link