/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 vote130 views1 answer
How to change uppercase to lowercase and spaces to _ in php
PHP
3 votes142 views2 answers
Wp do sql query from function
PHP Wordpress
10 votes160 views2 answers
Create model in laravel command line
PHP Laravel
0 vote84 views1 answer
Acf get all checkbox options
PHP
2 votes126 views1 answer
Php switch case multiple values per line
PHP
2 votes116 views3 answers
Php reverse string
PHP
1 vote132 views1 answer
Php remove numbers from string
PHP
17 votes150 views3 answers
Wordpress max memory limit
PHP Wordpress
7 votes145 views4 answers
How get role of user in laravel spatie
PHP Laravel
0 vote122 views1 answer
Symfony see all make command
PHP