Timestamp for a column in Oracle

  ------------------------------------------------------------------------------------------------------------
         Timestamp for a column    ------------------------------------------------------------------------------------------------------------
    select to_timestamp ('10-Jan-2010 11:10:10.456632', 'DD-Mon-YYYY HH24:MI:SS.FF') from dual

    Sample code:----------------------
    For example insert into timestamp column of TABLE times(kol1 TIMESTAMP):

    insert into times(kol1 ) values (timestamp'2010-01-10 06:30:00.00223344');
    insert into times(kol1 ) values (localtimestamp);

    TABLE times(kol1 TIMESTAMP WITH TIME ZONE)
    INSERT INTO times(kol1) VALUES (timestamp'2010-01-10 09:00:00.00224455'); -- uses session timezone
    insert into times(kol1) values ( timestamp'2010-01-10 10:23:00.333333 US/Eastern'); -- with timezone name
    insert into times(kol1) values ( timestamp'2010-01-10 10:23:00.333333 EST'); -- with timezone abbrevation
    insert into times(kol1 ) values (localtimestamp);
    insert into times(kol1 ) values (systimestamp);
    insert into times(kol1 ) values (current_timestamp);
    insert into times(kol1 ) values (CAST(sysdate AS TIMESTAMP));

    select to_timestamp ('10-Jan-2010 11:10:10.456632', 'DD-Mon-YYYY HH24:MI:SS.FF') from dual;
    ------------------------------------------------------------------------------------------------------------