/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

2 votes303 views3 answers
Make model -mcr laravel
PHP Laravel
0 vote277 views1 answer
Phpstorm check version
PHP
0 vote298 views2 answers
Wpdb get results foreach
PHP
1 vote324 views1 answer
Php connect to postgresql
PHP
27 votes356 views3 answers
How to migrate a specific table in laravel
PHP Laravel
13 votes318 views6 answers
How to redirect to another page in php
PHP
0 vote273 views1 answer
Laravel token logout
PHP
0 vote332 views1 answer
Parse data from xml CDATA php
PHP
6 votes320 views3 answers
Current time in laravel migration
PHP
7 votes291 views4 answers
With message in laravel
PHP