/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 vote250 views1 answer
Php huruf besar di awal
PHP
2 votes274 views1 answer
Php array unique array to string conversion
PHP
5 votes282 views3 answers
Mobile number validation in laravel 8
PHP Laravel
1 vote237 views1 answer
Save error cakephp 2
PHP
1 vote261 views2 answers
Database//Eloquent//Model.php laravel errror array t- string conversion
PHP
0 vote282 views1 answer
Laravel api error return homepage
PHP Laravel
1 vote269 views3 answers
Laravel eloquent to array key value
PHP
0 vote242 views1 answer
Laravel post index method
PHP
0 vote255 views2 answers
Launch uikit modal from php
PHP
25 votes269 views1 answer
Php online editor
PHP