/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 votes247 views2 answers
How to get the list of available timezones in php
PHP
2 votes227 views5 answers
Add key value array php
PHP
0 vote221 views1 answer
Php send response without quitting
PHP
0 vote222 views1 answer
Convert stdclass to json in php
PHP
0 vote248 views1 answer
A facade root has not been set laravel 7
PHP Laravel
0 vote261 views1 answer
Get database columns laravel
PHP Laravel
43 votes237 views2 answers
Php cant upload gif
PHP
0 vote220 views1 answer
Php decode stdclass object
PHP
24 votes209 views6 answers
Validation error message in laravel
PHP
2 votes226 views2 answers
Run composer with specific php version
PHP