Re: Getting sysdate across a DB link

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sun, 02 Mar 2003 22:08:40 +0100
Message-ID: <7hs46vk3i7emco4eu2ficp5236ammnb6lk@4ax.com>

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. Received on Sun Mar 02 2003 - 15:08:40 CST