Issue while inserting through DECODE function

[Girish Kanakagiri]

SQL>desc tab_dup;
 
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 CODE                                      NOT NULL VARCHAR2(6)
 BYJE                                               DATE
 
SQL>  insert into tab_dup (CODE, BYJE) values('ABC',TO_DATE('20120111070154', 'YYYYMMDDHH24MISS'));
 
1 row created.
 
SQL>  select to_char(BYJE,'YYYYMMDDHH24MISS') FROM tab_dup WHERE CODE='ABC';
 
TO_CHAR(BYJE)
--------------
20120111070154
 
 
SQL> delete from tab_dup where CODE='ABC';
 
1 row deleted.
 
SQL> commit;
 
Commit complete.
 
SQL> insert into tab_dup (CODE, BYJE) values('ABC',DECODE(TO_DATE('20120111070154', 'YYYYMMDDHH24MISS'),'19800101000000', NULL, TO_DATE('20120111070154', 'YYYYMMDDHH24MISS')));
 
1 row created.
 
SQL>  select to_char(BYJE,'YYYYMMDDHH24MISS') FROM tab_dup WHERE CODE='ABC';
 
TO_CHAR(BYJE)
--------------
20120111000000
 

When inserted at line number 27, using decode function; it is not storing hour minute second & thus they are coming as 000000. I have to use decode because the value from the parent table may be null & in that case this will help but the truncation should not happen because of decode & thus it should work same way when inserted through line 8.

Please provide the necessary changes to decode function or any other alternative.

[PsychoCoder]

First and foremost what database is this, that would greatly help in finding a solution.

[Girish Kanakagiri]

Oracle.
connect by below string to the ip through putty :
SQLPLUS userid/password