/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

50 votes297 views6 answers
Add new column in laravel migration
PHP Laravel
0 vote142 views1 answer
Comment acceder à la base de données phpmyadmin sur mac ave
PHP
0 vote126 views1 answer
Nova laravel image
PHP
1 vote154 views1 answer
Laravel date rule before 18 years ago
PHP Laravel
9 votes90 views2 answers
Laravel collection filter
PHP Laravel
0 vote144 views1 answer
Find the next 7 date data in laravel eloquent
PHP
29 votes126 views6 answers
Php loop through array
PHP
0 vote121 views2 answers
How to sent request in php
PHP
6 votes125 views5 answers
Setcookie php
PHP
1 vote144 views1 answer
Using middleware auth laravel in controller constructor
PHP Laravel