Oracle Decode function results with different formats
    SELECT DECODE (SYSDATE, SYSDATE + 1, NULL, SYSDATE)
      FROM DUAL;

  
    SELECT DECODE (SYSDATE, SYSDATE + 1, TO_DATE (NULL), SYSDATE)
      FROM DUAL;

  

why am i getting the results in different formats from the queries above?
 
i am using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

Oracle Decode function results with different formats
===

    SELECT DECODE (SYSDATE, SYSDATE + 1, NULL, SYSDATE)
      FROM DUAL;

  
    SELECT DECODE (SYSDATE, SYSDATE + 1, TO_DATE (NULL), SYSDATE)
      FROM DUAL;

  

why am i getting the results in different formats from the queries above?
 
i am using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
