Thanks everbody for all the insight.

I have posted my issue in oracle forum as well and am yet to receive any reply.

Unfortunately we have no control over the third party...

When I run this command

SELECT CONVERT(VARCHAR(35),source_id,121) FROM test@dblink_test

I get the following error:ORA-00936: missing expression....hence I am not even able to issue this command..

I am running through Toad.I have a...

currently im not trying to insert into Oracle.In oracle for insertion I have the column as Timestamp(9).

Currently Im just trying to select from Sql server via Oracle. and I am...

Thanks...the example u provided works in oracle.

But when i try to exceute this query to get values from sql server table it fails and gives an error date format...

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...

Through an ODBC Connection.

Sql Server -2008

Using SQL SERVER Native client 10.0 driver version 2009.100.1600.01

Then created a dblink in oracle to use the ODBC connection to get the data.

We have Oracle...

I meant to say milliseconds....whatever it records after seconds I want to bring it over to oracle.

any value after seconds is currently becoming 00000 in oracle.

Also I tried using to_char...