/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 votes161 views1 answer
Laravel middleware route
PHP Laravel
0 vote153 views1 answer
Check if data inserted in database wordpress plugin
PHP
0 vote169 views2 answers
Catch any exception php
PHP
2 votes193 views4 answers
Laravel htaccess
PHP
1 vote169 views2 answers
Php match copy match
PHP
2 votes148 views2 answers
Get template name wordpress
PHP
1 vote162 views1 answer
Start laravel queue
PHP
0 vote161 views1 answer
Wordpress execute query
PHP
0 vote210 views2 answers
Laravel collection search by value
PHP Laravel
0 vote189 views1 answer
Get user symfony
PHP Symfony