INSERT INTO table1 values(<id>, <firstName>, <createdTime>);

INSERT INTO table1 values(1, "John", TIMESTAMP '06-APR-14 06.00.42.000000000 PM ASIA/SINGAPORE');

SQL Error: ORA-01843: not a valid month
01843. 00000 -  "not a valid month"

INSERT INTO table1 values(1, 'John',
  TIMESTAMP '2014-04-06 18:00:42.0 ASIA/SINGAPORE');

INSERT INTO table1 values(2, 'John',
  TO_TIMESTAMP_TZ ('06-APR-14 06.00.42 PM ASIA/SINGAPORE',
    'DD-MON-RR HH:MI:SS AM TZR'));