Re: Getting sysdate across a DB link

From: John Russell <netnews5_at_johnrussell.mailshell.com>
Date: Sat, 08 Mar 2003 07:02:11 GMT
Message-ID: <v15j6vc1322c2fhtk9tfl1jesnvhjg5unf@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 Received on Sat Mar 08 2003 - 01:02:11 CST