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!

use a SQL SERVER get date in query

18063Jan 15 2008 — edited Jan 16 2008

I want to constrain my returned data by a change date to just return the last rolling 30 days of data. When I use sysdate, I find the plan is to retreive ALL data across the dblink, and then filter it on the Oracle side.

Is there any way I can use the Sql Server getdate() function, something like

select * from remote@ss_link
where upd_date >= getdate() - 30

Problem - how do I get Oracle to pass the Sql Server specific function call to Sql Server? [BTW I'm on an old version of Oracle...]

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2008

Added on Jan 15 2008

#heterogeneous-connectivity

1 comment

3,598 views