/PHP/Oci_execute(): ORA-01810: format code appears twice in

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

//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.

Source: stackoverflow.com

Similar codes

0 vote227 views1 answer
In Connection.php line 664: could not find driver (SQL: select * from information_schema.tables where table_schema = news and table_name = migrations) In Connector.php line 67: could not find driver
PHP
2 votes222 views1 answer
Laravel's collection pagination
PHP
0 vote166 views1 answer
Get category name form single post wordpress
PHP
1 vote201 views1 answer
CURL : Get elements by class name
PHP
1 vote214 views1 answer
Check if delete query was successful laravel
PHP
0 vote224 views1 answer
Laravel route name with parameters
PHP Laravel
14 votes246 views3 answers
Get extension from filename php
PHP
0 vote245 views1 answer
Laravel form old value array
PHP Laravel
0 vote219 views1 answer
Laravel use variable inside callback function
PHP
0 vote217 views2 answers
Laravel General error: 1215 Cannot add foreign key constraint"
PHP