/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 vote157 views1 answer
Textarea autocomplete phpmyadmin style
PHP
0 vote184 views1 answer
Php mysql remove by timestamp older than a month
PHP
0 vote175 views1 answer
Saber value ao escolher combobox php
PHP
0 vote241 views1 answer
Php mysql insert timestamp now
PHP
0 vote547 views1 answer
Route login not defined how to laravel problems fixed
PHP
1 vote225 views5 answers
Laravel collection methods
PHP Laravel
3 votes317 views2 answers
Two condition in one laravel query
PHP Laravel
6 votes157 views2 answers
Laravel findorfail
PHP
2 votes192 views1 answer
Check if value is not null in db laravel
PHP Laravel
11 votes165 views5 answers
Laravel check auth
PHP