/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 vote105 views1 answer
Php remove html tag wrap
PHP
10 votes68 views2 answers
Laravel migration default value not working
PHP Laravel
2 votes143 views3 answers
Call stored procedure in laravel
PHP Laravel
0 vote105 views1 answer
Parse data from xml CDATA php
PHP
1 vote113 views1 answer
Laravel export make comman
PHP Laravel
0 vote99 views1 answer
Get current page name for page active class
PHP
0 vote145 views1 answer
Symfony user online
PHP Symfony
0 vote118 views2 answers
Nested array in laravel
PHP Laravel
0 vote92 views1 answer
Parent in php
PHP
1 vote93 views1 answer
Human readable date laravel
PHP