Re: Getting sysdate across a DB link

From: Just Another User <zzz_at_zzz.zzz>
Date: Sat, 08 Mar 2003 23:28:34 GMT
Message-ID: <C0vaa.69729$gf7.13708314@news4.srv.hcvlny.cv.net>

"John Russell" <netnews5_at_johnrussell.mailshell.com> wrote in message news:v15j6vc1322c2fhtk9tfl1jesnvhjg5unf_at_4ax.com...
> On Mon, 03 Mar 2003 21:00:49 +0100, Jaap W. van Dijk
> <j.w.vandijk.removethis_at_hetnet.nl> wrote:
>
> >On Sun, 02 Mar 2003 15:04:47 -0800, DA Morgan
> ><damorgan_at_exesolutions.com> wrote:
> >
> >...
> >>> 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.
>
> The obvious way seems to me to be to write a stored function on the
> other server, returning a date. Then
>
> declare
> right_now date;
> begin
> right_now := get_time_from_other_server_at_other_server;
> end;
> /
>
> John

Shouldn't this work?
select sysdate from dual_at_other_server; Received on Sat Mar 08 2003 - 17:28:34 CST