/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

3 votes147 views3 answers
Sum row data and get all data eloquent laravel
PHP
18 votes169 views6 answers
Redirect to route laravel
PHP Laravel
0 vote164 views2 answers
Laravel pagination vuetify
PHP
0 vote181 views1 answer
Remove controller cache laravel
PHP Laravel
14 votes130 views3 answers
Get extension from filename php
PHP
0 vote155 views2 answers
How to add woocommerce cart counter
PHP
-1 vote184 views1 answer
Pentationic scale jazzzz
PHP
0 vote152 views1 answer
Wordpress check if class exists
PHP Wordpress
1 vote161 views1 answer
Return response array laravel
PHP
1 vote156 views3 answers
Laravel 6 orderby
PHP