/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 vote307 views1 answer
Boot add schema in laravel
PHP Laravel
0 vote317 views1 answer
SET DEFAULT hide title astra wordpress
PHP Wordpress
0 vote255 views4 answers
Mysqli_query() expects parameter 1 to be mysqli, string given
PHP
0 vote267 views1 answer
What is the name of scripting engine in PHP?
PHP
31 votes276 views1 answer
Php nombre de caractère
PHP
63 votes398 views6 answers
Laravel artisan clear cache
PHP Laravel
0 vote260 views1 answer
How to unpack the html code encrypted with php curl
PHP
18 votes255 views3 answers
Php pop off the first character of string
PHP
1 vote254 views1 answer
Convert date to reverse date in php
PHP
2 votes271 views3 answers
Laravel get query result as array
PHP