/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 vote238 views1 answer
Nested attributes - PHP 8.1
PHP
8 votes215 views1 answer
Laravel show routes artisan
PHP Laravel
0 vote186 views1 answer
Wordpress user enumeration
PHP
0 vote209 views1 answer
Laravel check if model relation exists
PHP Laravel
1 vote202 views1 answer
Model json laravel accessor to convert to array
PHP Laravel
5 votes225 views2 answers
Laravel 5 use env variable in blade
PHP Laravel
4 votes334 views1 answer
Php find multiple strings in string
PHP
1 vote218 views1 answer
Laravel get class name
PHP Laravel
33 votes190 views5 answers
Php elseif
PHP
0 vote180 views1 answer
Php is object
PHP