/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 vote296 views1 answer
Send OTP php
PHP
0 vote342 views1 answer
Fallo al conectar al servidor ftp wordpress
PHP Wordpress
22 votes256 views2 answers
The PHP Else If statement must be preceded by an If statement before it can be used.
PHP
7 votes327 views3 answers
Laravel get latest
PHP
0 vote311 views1 answer
Functions file erased wordpress
PHP
1 vote299 views1 answer
Wp add_action
PHP
0 vote297 views1 answer
How to disable Gutenberg / block editor for certain post types
PHP
2 votes283 views1 answer
Laravel difference between current time and created time
PHP
1 vote319 views2 answers
Create role spatie
PHP
0 vote335 views1 answer
Access-control-allow-origin php laravel
PHP Laravel