/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

43 votes233 views2 answers
Array count items
PHP
5 votes257 views4 answers
Laravel auth register false
PHP Laravel
26 votes232 views6 answers
Laravel migration rollback
PHP
3 votes239 views2 answers
How to fix PHP Fatal error: Allowed memory size of 1610612736 bytes exhausted
PHP
0 vote266 views3 answers
Mail sending setting magneto for mailhog
PHP
1 vote231 views2 answers
Enable socket in php
PHP
3 votes232 views2 answers
Clear log file laravel command
PHP
8 votes269 views3 answers
Laravel model::query
PHP Laravel
0 vote283 views1 answer
Check laravel first null
PHP Laravel
4 votes246 views2 answers
Remove index.php from url htaccess
PHP