Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB LINK Oracle to SQL Server SQL Server TimeStamp converts to Oracle Date

891464Mar 13 2012 — edited Mar 19 2012

Hi All,

I have created a DB link between Oracle 10g 10.2.0.5 to SQL server 2005 using Oracle 11g gateway. When I execute a query from Oracle that selects data from SQL server using the DBLINK then the column value of type Timestamp from SQL server gets converted to Date data type in Oracle and it losses the time value.

Is there some way (in gateway configurations or in select query sql ) that the SQL server data type Timestamp gets converted to Oracle's Timestamp?

Please help.

Best Regards!

Irfan

Edited by: irf_mas on Mar 13, 2012 3:23 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2012

Added on Mar 13 2012

#heterogeneous-connectivity

3 comments

2,329 views