SQL & PL/SQL

Hi Experts,

I have to concatenate a date(not sysdate) with the system time and store it in a column having datatype as DATE...

So I tried like this....

   SELECT

              TO_CHAR (C_DATE, 'DD-MON-YYYY')

           || ' '

           || TO_CHAR (SYSDATE, 'HH:MI:SS PM')

    FROM   DUAL;

But while inserting the output of the above query in my table it throws error like this...

ORA-01830: date format picture ends before converting entire input string

Is there any possibility to achieve this....

Thanks in advance.