Re: Getting sysdate across a DB link

"Jaap W. van Dijk" wrote:

> On Sun, 02 Mar 2003 17:27:54 +0000, Paul Moore
> <gustav_at_morpheus.demon.co.uk> wrote:
>
> ...
> >> 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 ?
> >
> >That works, and seems to get the date from the remote server (at
> >least, the result seems to be a few seconds out - the difference isn't
> >enough to be glaringly obvious, and I can't reset the date on the
> >remote server).
> ...
>
> If nothing helps, let's read the manual:
>
> 'SYSDATE returns the current date and time. Requires no arguments. In
> distributed SQL statements, this function returns the date and time on
> your local database.'
>
> (from the 8i SQL Reference Manual).
>
> Jaap.

He knows that. He is trying to get the time from the other machines.

With respect to your previous post ... get_time can not be used to get what he needs.

Daniel Morgan Received on Sun Mar 02 2003 - 17:04:47 CST