Re: Getting sysdate across a DB link

On 28 Feb 2003 08:53:10 -0800, paul.moore_at_atosorigin.com (Paul Moore) wrote:

...
>PS I just tried using inline views:
>
> select (local - remote)*24*3600 diff
> from
> (select sysdate local from dual) l,
> (select sysdate remote from dual_at_t) r;
>
> That didn't work either :-(

...

To exclude errors (what error did you get by the way?) from other causes than querying over the database link, what happens if you try:

select sysdate from dual_at_t ?

Jaap. Received on Sat Mar 01 2003 - 17:37:17 CST