Re: Sysdate from remote database

From: Marc <E.Mail_at_address.com>
Date: Thu, 6 Apr 2000 14:27:54 +0200
Message-ID: <8chvt4$h2f$1@vkhdsu24.hda.hydro.com>

A second solution (besides the creation of a view on the remote database as mentioned in a previous post) is to use package dbms_sql_at_db1 to fetch the sysdate, especially if you are not allowed to create views on the remote database, and you are dealing with unwilling database administrators at the remote site...

Marc

Marek JóŸwik wrote in message ...
>Hi!
>
>I have small problem. I'd like to call sysdate from
>remote database. I have two databases (DB1 and DB2) and
>database link from DB2 to DB1. Assume that time in DB1 is
>10:45 and time in DB2 is 10:50. I connect to database DB2
>and query:
>select to_char(sysdate, 'HH24:MI') from dual;
>It returns 10:50.
>select to_char(sysdate, 'HH24:MI') from dual_at_db1;
>It returns 10:50 too.
>
>Calling "select to_char(sysdate_at_db1, 'HH24:MI')
>from dual" doesn't work.
>
>
Received on Thu Apr 06 2000 - 07:27:54 CDT