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