• select to_char(sysdate,'mm/dd/yyyy hh24:mi:ss.FF') from dual----

    this gives me an error date format not recognized in oracle

    select to_char(sysdate,'mm/dd/yyyy hh24:mi:ss.ssss') from dual

    gives me

    04/10/2012 16:00:36.3636

    Note that milliseconds is just a repeat of seconds

    If I try this from oracle to sql server--gives me an error : format code appears twice

    select to_timestamp(source_id,'yyyy-mm-dd hh24:mi:ss:ssss') from xyz@dblink_test;

    If I issue this query ----it does not give me milliseconds just repeats the seconds

    select to_char(source_id,'yyyy-mm-dd hh24:mi:ss:ssss') from

    xyz@dblink_test;

    output--3051-01-01 00:00:22:2222