/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

4 votes230 views6 answers
Laravel jwt
PHP
0 vote136 views1 answer
Php return associative array
PHP
2 votes115 views1 answer
PHP get_url
PHP
2 votes134 views1 answer
Wp config define site url code
PHP Wordpress
0 vote140 views1 answer
MySQL eqSql Connection
PHP
4 votes123 views3 answers
Laravel restore soft delete
PHP
4 votes122 views1 answer
Php get php.ini location from termina
PHP
2 votes114 views1 answer
Making visible or hidden attributes from Eloquent temporarily
PHP
0 vote166 views1 answer
Laravel uuid not showing in query
PHP Laravel
0 vote107 views1 answer
Fast excel export laravel
PHP