/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 vote384 views1 answer
Laravel interview questions
PHP
2 votes324 views2 answers
Php check if json
PHP
2 votes370 views1 answer
Get current user first and last name wordpress
PHP
0 vote354 views1 answer
Checks whether the session is set or not, if not it will redirect the user to login page.
PHP
2 votes340 views1 answer
Cakephp 2 savefield
PHP
0 vote368 views1 answer
Laravel storage goes to 404 page. (Symlink not working)
PHP Laravel
0 vote345 views1 answer
Total days between two dates carbon
PHP
0 vote307 views1 answer
Union of two arrays in php
PHP
0 vote316 views1 answer
Laravel change db connection on the fly
PHP
0 vote393 views1 answer
Wordpress single post template managwr
PHP