/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 vote163 views1 answer
Cakephp extract array
PHP
0 vote158 views1 answer
Php check if extension is installed
PHP
0 vote136 views1 answer
Check dir php
PHP
0 vote137 views1 answer
Query-data-from mysql and php
PHP
2 votes139 views2 answers
Check number is positive or negative in php
PHP
1 vote194 views1 answer
How to add attribute to the request object in laravel
PHP Laravel
0 vote173 views1 answer
Symfony 2.8 create database from entities
PHP
4 votes154 views2 answers
Laravel form method delete
PHP Laravel
0 vote145 views1 answer
Wordpress hook for newly published post
PHP
1 vote136 views2 answers
Db name laravel
PHP